Share Percentage on Stacked Graph

[MikeHerb]

Hi I am having a problem getting the share percentage off of my stacked graph:

you see the percentage its 100% all the time for all segments. the expression I'm using for this is:

Sum([RevnueUSD_Stay])/Sum( TOTAL <EndOfMnt.YearMonth> [RevnueUSD_Stay])

[Anil_Babu_Samineni]

Please convert into Straight table and see if there is any variation after you have done sorting if you have many records? Also, Please share sample application to test.

[MikeHerb]

hi @Anil_Babu_Samineni 

Im sorry I'm really new to Qlik Sense how do I create a sample application? 

[MikeHerb · Accepted solution]

I have solved it! 

it is lacking the auto calendar expression 

sum( RevnueUSD_Stay) / sum(TOTAL <[EndOfMnt.autoCalendar.YearMonth]> RevnueUSD_Stay)