How to use this one in SetAnalysis

[#1]

One column for each product with the Company products first..,How to use this one in SetAnalysis..,

Please help me..

[#2]

If i inderstood your doubt ....something like this:

sum({$<YOUR_PRODUCT_DIMENSION={'YOUR_PRODUCT'}>} Sales)

for example to sum you sales!!!!!

[#3]

Hello,

You can Add a calculate dimension for get the max product for each Company :

=Aggr(firstsortedvalue (product , Amount),Company)

[#4]

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.