Is it possible for you to attach a packaged workbook? It's hard to answer your question without being able to work with your day
Hey, i have attached the sample packaged workbook.
In the workbook Grand totals are displaying as value 0, where i want the sum of the values.
Thanks in advance
Can someone try to help me on the above question?
I've taken a look at your workbook, but I can't quite figure out what you're wanting to total up. From what I see, you're calculating a % of total calculation based on COUNT(Appid):
Then, the next calculation (which you're trying to do a grand total of) is the % difference of the previous calculation? If that's the case, then what does your desired output look like?
Hey, thanks for looking in to this.
This is actually for calculating shift change(psi).
in the sample workbook which i have attached, the grand total should be the sum of the values like in the image below
so, my calculated values are absolutely correct, its just that the Grand total should display the sum of the columns.
Naveen - I am trying to calculate PSI too - were you able to solve this?