Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
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)
Expression:
sum(Field_Name)/sum(total <Month>Field_Name)
Number Format: Fixed to 2 digits & show in %
You can simplify that expression:
Sum(Aggr(sum(Sales)/sum(TOTAL Sales),Month,[Disposition Type]))
to
Sum(Sales)/sum(TOTAL <Month> Sales)
Thank You jontydkpi
I will update the same in my attachment..
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.
-Rob
works now. How can I sort it ascending by month?