-
1. Re: Need help to convert the Continuous Measure to measure
Walt Reed Mar 17, 2017 7:18 AM (in response to Naveen B)Hi Naveen,
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
-
2. Re: Need help to convert the Continuous Measure to measure
Naveen B Mar 17, 2017 10:23 PM (in response to Walt Reed)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
-
3. Re: Need help to convert the Continuous Measure to measure
Naveen B Mar 20, 2017 2:46 AM (in response to Naveen B)Hello ,
Can someone try to help me on the above question?
Thanks
Naveen
-
4. Re: Need help to convert the Continuous Measure to measure
Walt Reed Mar 20, 2017 7:05 AM (in response to Naveen B)Hi Naveen,
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?
Walt
-
5. Re: Need help to convert the Continuous Measure to measure
Naveen B Mar 20, 2017 8:53 AM (in response to Walt Reed)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.
thanks
naveen
+91 9916290906
-
6. Re: Need help to convert the Continuous Measure to measure
David Switzer Oct 18, 2017 1:50 PM (in response to Naveen B)Naveen - I am trying to calculate PSI too - were you able to solve this?