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 ?
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 .