Help with Pivot Chart Expression

[#1]

HI

I am trying to create a Pivot Chart and calculate the contribution (relative to column) however I can't get it right.

My Chart looks like:

and my expression for Current Year is =count({<range={'CURRENT YEAR'}>}dl_descr)
How can I create the SOV in a pivot, can only get it to work in straight table

[sunny_talwar]

Not entirely sure what you are trying to do, would you be able to share a sample?

[Anil_Babu_Samineni]

What you have tried for SOV for prev year??

[#4]

This is what I am trying to create:

The table is a straight table that I was attempting to get the expression correct so that I could pivot the chart, so prev SOV is the same expression as Current/Previous Prod adv but with relative

What I need to do is to calculate the contribution percentage of each row to total of column

[Anil_Babu_Samineni]

Would you provide expression

OR

Sum(TOTAL <YourExpression> Sales)