Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Forgot to ignore Month selection in 2015 expression. Try this for 2015
=SUM({<Year = {2015}, Month>}Aggr(IF(
SUM({<Year = {2015}, Month>}NUMERATOR)/SUM({<Year = {2015}, Month>}DENOMINATOR)>= Only({<Year = {2015}, Month>}C_PtileBeg) and
SUM({<Year = {2015}, Month>}NUMERATOR)/SUM({<Year = {2015}, Month>}DENOMINATOR)<= Only({<Year = {2015}, Month>}C_PtileEnd), Only({<Year = {2015}, Month>}C_Star)) * Only({<Year = {2015}, Month>}Weight), C_Star,_CMS_ThresholdMeasureYearKey,Month))
/
SUM({<Year = {2015}, Month>}Weight)
2016 stays the same:
=SUM({<Year = {2016}, Month>}Aggr(IF(
SUM({<Year = {2016}, Month>}NUMERATOR)/SUM({<Year = {2016}, Month>}DENOMINATOR)>= Only({<Year = {2016}, Month>}C_PtileBeg) and
SUM({<Year = {2016}, Month>}NUMERATOR)/SUM({<Year = {2016}, Month>}DENOMINATOR)<= Only({<Year = {2016}, Month>}C_PtileEnd), Only({<Year = {2016}, Month>}C_Star)) * Only({<Year = {2016}, Month>}Weight), C_Star,_CMS_ThresholdMeasureYearKey,Month))
/
SUM({<Year = {2016}, Month>}Weight)
I can't see your QVW, but in general, you should be able to achieve what you want using set analsis.
Something like
=Sum({<Year =, Month = >} Value)
I agree, can't see anything attached, but the usually ignore using {<Year, Month>} from all aggregation functions including Only
Sorry I forgot to attach the file. PFA now...:)
Bro the one which you sent me is changing when I'm making selections in the year and month. Please find the attached qvw file now...
Check now
Bro.. I'm trying to download the file but its getting failed. Could you please post the expressions, so that I'll copy into my dashboard.
2016:
=SUM({<Year = {2016}, Month>}Aggr(IF(
SUM({<Year = {2016}, Month>}NUMERATOR)/SUM({<Year = {2016}, Month>}DENOMINATOR)>= Only({<Year = {2016}, Month>}C_PtileBeg) and
SUM({<Year = {2016}, Month>}NUMERATOR)/SUM({<Year = {2016}, Month>}DENOMINATOR)<= Only({<Year = {2016}, Month>}C_PtileEnd), Only({<Year = {2016}, Month>}C_Star)) * Only({<Year = {2016}, Month>}Weight), C_Star,_CMS_ThresholdMeasureYearKey,Month))
/
SUM({<Year = {2016}, Month>}Weight)
2015:
=SUM({<Year = {2015}>}Aggr(IF(
SUM({<Year = {2015}>}NUMERATOR)/SUM({<Year = {2015}>}DENOMINATOR)>= Only({<Year = {2015}>}C_PtileBeg) and
SUM({<Year = {2015}>}NUMERATOR)/SUM({<Year = {2015}>}DENOMINATOR)<= Only({<Year = {2015}>}C_PtileEnd), Only({<Year = {2015}>}C_Star)) * Only({<Year = {2015}>}Weight), C_Star,_CMS_ThresholdMeasureYearKey,Month))
/
SUM({<Year = {2015}>}Weight)
Anna.... Its working fine when I'm making selections in the Year But when I'm selecting the Month the graph is changing...
Forgot to ignore Month selection in 2015 expression. Try this for 2015
=SUM({<Year = {2015}, Month>}Aggr(IF(
SUM({<Year = {2015}, Month>}NUMERATOR)/SUM({<Year = {2015}, Month>}DENOMINATOR)>= Only({<Year = {2015}, Month>}C_PtileBeg) and
SUM({<Year = {2015}, Month>}NUMERATOR)/SUM({<Year = {2015}, Month>}DENOMINATOR)<= Only({<Year = {2015}, Month>}C_PtileEnd), Only({<Year = {2015}, Month>}C_Star)) * Only({<Year = {2015}, Month>}Weight), C_Star,_CMS_ThresholdMeasureYearKey,Month))
/
SUM({<Year = {2015}, Month>}Weight)
2016 stays the same:
=SUM({<Year = {2016}, Month>}Aggr(IF(
SUM({<Year = {2016}, Month>}NUMERATOR)/SUM({<Year = {2016}, Month>}DENOMINATOR)>= Only({<Year = {2016}, Month>}C_PtileBeg) and
SUM({<Year = {2016}, Month>}NUMERATOR)/SUM({<Year = {2016}, Month>}DENOMINATOR)<= Only({<Year = {2016}, Month>}C_PtileEnd), Only({<Year = {2016}, Month>}C_Star)) * Only({<Year = {2016}, Month>}Weight), C_Star,_CMS_ThresholdMeasureYearKey,Month))
/
SUM({<Year = {2016}, Month>}Weight)