Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Oct 20, 2014 7:47:12 AM
sakamsureshbabu
i what create piovt or stright table like this how it is ....
Hi Suresh
The only thing you need to do is to create New Sheet Object -> Chart -> Select Pivot table...
and then for dimensions select Brand, DB Name, Branch and for expression, Qty and Amount.
Initially your table will contain three dimension columns, so you can drag the first (Brand) column and pivot it on the top of the table horizontally.
Then, your Brand dimension will appear horizontally in your Pivot table.
I hope this helps
Agis