I was trying get QV to do something similar to the image below but I am stumped. Any advise?
Is this a pivot table?
How are you trying to get the month row?
Yes it is a pivot table.
Check the Attachment. May be helps..
Just used Pivot with the expression like
Sum(Aggr(sum(Sales)/sum(TOTAL Sales),Month,[Disposition Type]))
As per jontydkpi Suggestion..
Sum(Sales)/sum(TOTAL <Month> Sales)
You can simplify that expression:
Thank You jontydkpi
I will update the same in my attachment..
Number Format: Fixed to 2 digits & show in %
I got the expression part down but it is still not showing the months in each column. It looks like this right now;.
Drag the "Lead Month" column heading to the upper right corner of the chart and drop it there.
works now. How can I sort it ascending by month?
Put the Month field as "Sort by ... Numeric Value".
Retrieving data ...