Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
is there an object which can work like the pivot chart in Excel does? I mean I want to add a vertical dimension, an horizontal dimension and then a expression which fills the cells with the proper numbers.
I could only find the Pivot table in which the dimensions can be only vertical.
Any suggestions please? Thanks a lot.
Drag a dimension from row area and drop it on a top of the pivot table.
Drag a dimension from row area and drop it on a top of the pivot table.
In a PivotTable table you can drag and drop your dimensions to the vertical or horizontal, no problem. I do not understand what other features you need in this chart but I'll be glad to help. Please provide more details.
Thanks to both of you 🙂 ! I didn't know of the drag and drop feature. Bye.
Hi
Great solution. I moved one of my dimension to horizontal and it works. We also need the totals at the end of each column and each row.
How we could achieve that? Please help