Totaling Dimension similar to Dimension Limits

[khunhoff]

I have a field called MainPlanType.  The values of MainPlanType are 1,2,3,4,5,6.  

I currently have a Bar Chart using MainPlanType = 2,3,5, or 6 as a dimension and Year as another dimension.

I need to create a 'Total' value in MainPlanType that totals up the expression values for MainPlanType = 2,3,5 and 6 by Year.  I can't use the Show Total feature in Dimension Limits because I need it to give me the Total for each year - not the total for all MainPlanTypes for all years.

The kicker is I need this 'Total' to be able to be displayed in the same Bar Chart as the 4 MainPlanTypes.

Picture is just to show what is desired - values are not correct.

[Arthur_Fong · Accepted solution]

There you go :

Refer qvw attached for Total logic at script level.

Thanks and regards,

Arthur Fong