Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can I add a custom total row into a pivot table? This custom total is not the same as the total of the expression. For example, the expression I use is total count of customer, but in the total row, I want the overall total count of customer AND the total sales amount. I tried adding both into the expression, but the extra expression will repeat in the content of the table. (I only want the total, not the main table) Attached is the sample that I'm working on, and also the desired output in Excel format.
hi,
qv will tell you where you are in the pivot table with the dimensionality() function.
Taking your example the lowest cells (intersection of product and expression have dimensionality()=2, the country totals have dimensionality() = 1 and the product totals have it equal to zero.
you can now use and if clause to show different calculations in the same expression at different places in your table.
see attached qvw
hi,
But is it possible to create two rows instead of concatenating the two string together?
hi,
yes it is, altho' I am not completely sure I have understood your request.
Attached is a qvw with two rows, first expression is sum(Amount) the second is count(Customer) and only displays on the total rows.
hope this helps.
Yup.... I want something like this, but the 2nd expression is shown for each dimension... I only need it for the Total row.
nearest i can get is attached.
Hmmm... this can be use as a temporary solution. If only the Total can be adjusted then it would be great!
A modified version using the function secondarydimensionality() instead of dimensionality() is attached which shows total. Is this what you like to see?
Hi Kirshna,
The one shown by pat.agen is the one that I want. But you method also works, if I want the total on the left.
The issue now is that the cell height. Currently the sample is using the cell height 2, which make all the cells bigger. (I only want the total row to be bigger, not all the cells)