Month going across the top

[#1]

I was trying get QV to do something similar to the image below but I am stumped. Any advise?

[robert_mika]

Is this a pivot table?

How are you trying to get the month row?

[#3]

Yes it is a pivot table.

[settu_periasamy]

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)

[PradeepReddy]

Expression:

sum(Field_Name)/sum(total <Month>Field_Name)

Number Format: Fixed to 2 digits & show in %

[jonathandienst]

You can simplify that expression:

Sum(Aggr(sum(Sales)/sum(TOTAL Sales),Month,[Disposition Type]))

to

Sum(Sales)/sum(TOTAL <Month> Sales)

[settu_periasamy]

Thank You jontydkpi

I will update the same in my attachment..

[#8]

I got the expression part down but it is still not showing the months in each column. It looks like this right now;.

[rwunderlich]

Drag the "Lead Month" column heading to the upper right corner of the chart and drop it there.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#10]

works now. How can I sort it ascending by month?