line chart...

[smilingjohn]

Hi Expertise,

I have two dimension ,Severity and Week and expression has rangesum and this work perfectly in a pivot table .
But when i try to convert this a Line chart it doesn't work .
Can you please suggest what needs to be done to get this ?

DImension
Severity
Week

Expression :
rangeSum(Before(TOTAL Count({<Year*={">2015"},
Status-={'Bolt','Trifor','Hexa','Nexon'}>}ID)+Sum({1<Year=P(Year)>}0), 0,ColumnNo(TOTAL)))

Any help on this 

Thanks in Advance...

[anushree1]

Please try :

rangeSum(above(TOTAL Count({<Year*={">2015"},
Status-={'Bolt','Trifor','Hexa','Nexon'}>}ID)+Sum({1<Year=P(Year)>}0), 0,rowno(TOTAL)))

It would be better to get a sample to check the issue

[smilingjohn]

Hi I cant use rangesum(above  formula , 

As i am using weekly data as shown in the attachment , in a pivot  table i have made the Weekly date horizontal on top  and department vertical therefore i have cumulative column wise , and the expression i shared in my pivot table is giving accurate result . But this is not working in Line charts . 

Below expression used in pivot table :

rangeSum(Before(TOTAL Count({<Year*={">2015"},
Status-={'Bolt','Trifor','Hexa','Nexon'}>}ID)+Sum({1<Year=P(Year)>}0), 0,ColumnNo(TOTAL)))

Thanks in Advance

[smilingjohn]

Hi Any help on this 

[smilingjohn]

Is this not possible ?