Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I wisht to creat a colum that sums the total cuantity from de rows before.
Thank you
An example:
Header 1 | January | February | Total | |
---|---|---|---|---|
Article 1 | 10 | 10 | 20 | |
Article 2 | 10 | 10 | 20 | |
Article 3 | 10 | 10 | 20 |
Go to presentation tab, select partial sums for dimension month. If these are all expressions then just add them together
Hi Diego,
Thanx a lot for your reply.
I think this solution does not meet my expectations. I´m working with a Pivot Chart Table. Header 1 and Month are both Dimensions (Month Dimension has been moved over The expresion) Is there any way of having a Totals column ? the problem with partial sums is that I have a row not a column.
Anyone has ideas ¿?
In presentantion Tab - Show Partial Sum.
Hi diegogarrido,
why didn't you even try what marcsliving suggested ?
There is no problem to have that totals and he said you how to achive it ('Partial Sum' for month dimension). You can have sub totals for every dimension wether it horizontal or vertical.
I have your exact same problem. Did you solve it?