Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have a pivot table for sales by product by period, and the users of this file want to be able to sort by any column. Can this be done in a pivot table? I know you can simply double click on a column heading in a straight table and it will sort on that column, but they want the selected periods to be accross the page, but be able to sort by any column.
I have attached a sample file, it is pretty basic way of looking at it.
The chart looks like this.
I hope this all makes sense
Regards
Josh
Hi Ama,
I've only just seen your message (I don't think I received a notification) can you post the workbook in the forum for reference? I'm not 100% sure on what you need to achieve?
If I fail to respond, please contact me directly: richard.hemmings at bluevenninc dot com
Rich
Found the answer
Use the Dual function... it should go as below for the Dimension
=Dual(Product,aggr(sum(Sales), [Products]))
Hope this helps.
Doesn't works for me.
Works really well,
I would like to set up a default sorting if nothing is selected. Any idea how to do it please?
Something like:
IF( COUNT( %DisplayValue) <> 1,
by_default_sorting,
$(=(%SortingExpression) )
)
Thanks
The following solution by gwassenaar worked for me perfectly:
Is it possible to sort measure in pivot table using Qlik Sense?