Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guru's,
I am comparing current year vs last year against region using bar chart ,when I select filter 2015 it working fine with percentage format in y-axis ,when i select filter 2016 it is not working ,the y-axis still apperas number format .Both expression i have checked percentage check box in number tab.When I remove denominator it's working both filter. Any help.
I am using below expression.
Sum( {<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} Amount)
/
(Count( {<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} [Account Name])
Sum( {<Date={">=$(vCurrentYearStartDate) <=$(vCurrentYearToday)"}>} Amount)
/
Count( {<Date={">=$(vCurrentStartDate) <=$(vCurrentYearToday)"}>} [Account Name])
--Sateesh
Maybe you need to use the Set Analysis 1 for all records - as in ignore selections :
Sum( {1<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} Amount)
/
(Count( {1<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} [Account Name])
Sum( {1<Date={">=$(vCurrentYearStartDate) <=$(vCurrentYearToday)"}>} Amount)
/
Count( {1<Date={">=$(vCurrentStartDate) <=$(vCurrentYearToday)"}>} [Account Name])