Hi Guys and Gals,
I have a very basic order form where I display an inline view to view previous sales of the specific customer I select. I've done this by using a slice function.
I used a ref view to display the information more clearly, by sorting and grouping the data. The issue that I'm sitting with is that my product column, although set to group in the reference view, does not group and only gets sorted.
If I remove the row number data field from the Group By then I have blank lines between the Product line, but then the product field groups correct.
Any idea where I can start looking or ideas on how to correct this?
Tx,
R
Try the option 'Select All' into the FORM_ORDER_HISTORY slice
Unfortunately has no effect.
You could use the default group by option to group by products from the table view that you have already implemented.
Then you could use the sort option within the table view and ask users to sort by product whenever necessary. The image below shows sorting by the [Order Total] column in the table view, highlighted in yellow, On the left is grouping by Customer Name followed by the order status, highlighted in red.
The group by options in the table are as follows in the example above.
Additionally, if the users do not need to sort the table view elsewhere in the app, you could simply disable the table sort option for the users and set a default sort by product in the table view.
User | Count |
---|---|
26 | |
25 | |
25 | |
19 | |
17 |