Calculation % Share based upon Column Names.

[peachman]

Hi,

I have the following Pivot table structure (Simplified for Context) 

• Column 1 is 'YYYYQQ' where QQ is a quarter Number. Eg: 201701 is 2017 Quarter 1.
• Column 2 is my current % Share Values, but this % sahre split for everything within the table where i need it split by year.
• Column 3 is my desired output.

My Expression for Column 2 is as follows:

SUM(VOLUME) / SUM(TOTAL VOLUME)

I have tried several different expressions for column 3. one being: 

SUM({<[CSS_YEAR] = {'LEFT([CSS_QTR],4)'}>}VOLUME)

where year is YYYY and QTR is as mentioned about YYYYQQ. I have been trying to get it to aggregate on the date by taking the left of the QTR to just get the date elements. this expression gives me a results of 0.

201701	% Share (What I have now)	% Share (What I need)
Product 1	25%	50%
Product 2	25%	50%
201702
Product 1	25%	50%
Product 2	25%	50%

[Anil_Babu_Samineni · Accepted solution]

May be

SUM(VOLUME) / SUM(TOTAL <Product_Field_Name> VOLUME)