Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
One column for each product with the Company products first..,How to use this one in SetAnalysis..,
Please help me..
Hello,
You can Add a calculate dimension for get the max product for each Company :
=Aggr(firstsortedvalue (product , Amount),Company)
Hi,
Pull your dimension in pivot chart and make it horizental.
Attached sreen shots of how to drag and drop dimension ( Product ) from rows to columns.