Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to add % of Total in a Pivot Chart

I have what seems to be a very basic data cross-tab table to be built, but yet have not found a way to do this easily with QVW.

I have created a basic cross tab, Sales by Product (row) and Year (column). How do I add % of Total in this table, with total being total for a year?

I have attached the sample QVW. Any help would be greatly appreciated!

ST

1 Solution

Accepted Solutions
Not applicable
Author

Hi Sau,

Try this:

sum(Sales)/sum(TOTAL<Year> Sales)


See attached for more details.


Best,


Matt

View solution in original post

7 Replies
Not applicable
Author

Hi Sau,

Try this:

sum(Sales)/sum(TOTAL<Year> Sales)


See attached for more details.


Best,


Matt

Not applicable
Author

Hi Sau,


Did that work for you?


Best,


Matt

ecolomer
Master II
Master II

Here you have an example

P08.png

Anonymous
Not applicable
Author

Thank you very much! That worked too!

Anonymous
Not applicable
Author

Thank you for the speedy response Matt! It worked like a charm...

Much appreciated,

ST

Anonymous
Not applicable
Author

Let me throw you a zinger. What if my Year dimension is a drill-down group that has Year, Quarter, Month?

Or, actually what if the column has nested columns Year, Quarter, Month, that you can drill in, or expand (instead of a group)?

How can I make the formula dynamic to know the group level?

Thanks again,

ST

Anonymous
Not applicable
Author

I replied to my original post, but what if my Year dimension is a drilldown group that looks like this: Year, Quarter, Month?

st