Hi,
I'm developing a report in which I need to display Daily and Cumulative calculations. For the Daily computations, it is all showing correctly since it will just sum up and calculate base on the day, but for the Cumulative calculations in which I use the RUNNING-TOTAL() function, the results were all off.
I have 3 pairs of Daily and Cumulative calculations with different sets of dimension but have the same Date column. My suspect is that the Cumulative calculation is becoming inaccurate because of the added dimensions or columns (SEVERITY and %MET) in the report.
I've attached a sample excel. the dashboard sheet is what I would want to achieve and the details sheet is the source of the dashboard.
Kindly advise on how I can fix this. Thank you very much!