6 Replies Latest reply on Oct 18, 2017 1:50 PM by David Switzer

# Need help to convert the Continuous Measure to measure

I have created a calculated field  usig  measures, the calculation is as expected, but I want to use show column grand total option in Analysis tab.

when I select Totals-> show column grand totals.

the Grand Total row appers but the fields are blank.

the calculation image is attached

For example: X is the calculated field, when i drag it to marks, the measures option in X is grayed out, is this the reason for not showing up the column total? if so please help me how to get the grand totals of such  calculated field Continuous Measure.

Thanks

Naveen

• ###### 1. Re: Need help to convert the Continuous Measure to measure

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

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.

• ###### 3. Re: Need help to convert the Continuous Measure to measure

Hello ,

Can someone try to help me on the above question?

Thanks

Naveen

• ###### 4. Re: Need help to convert the Continuous Measure to measure

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

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

Naveen - I am trying to calculate PSI too - were you able to solve this?