9 Replies Latest reply on Jul 26, 2016 3:01 PM by Shinichiro Murakami

Grand total not working when I had to make the measure as discrete

I needed to make couple of measures as discrete in order to display a trend as a shape.  Now my grand total is not working..... any suggestion?

Attached is my sample workbook to better understand my question.  Thank you in advance!

• 1. Re: Grand total not working when I had to make the measure as discrete

I checked your workbook and find that your "Stage Trend" is not calculated field.

Then if that has multiple value in data as "String", G.Total will how both value.

I added calculated field as "Dummy_Trend"

[Dummy_Trend]

IF sum([TCV])>SUM([2016 rev Impact]) THEN "UP" ELSE "FLAT" END

In this case, G.Total follows the formula.

So, if you can replicate "Stage Trend" as calculated value, you can fix the problem on G.total.

Thanks,

Shin

9.2 attached,

• 2. Re: Grand total not working when I had to make the measure as discrete

Thanks for your response Shin but I'm looking for Grand total for TCV and 2016 Rev Impact.....

I used to have them both as continuous measure but had to switch to discrete to get a shape for "Trend Stage"  that's when I lost the grand total for TCV and 2016 Rev Impact.  So even if I do a calculated field for Stage Trend - Grand total not working for TCV and 2016 Rev Imapct

• 3. Re: Grand total not working when I had to make the measure as discrete

Here is another way to achieve same thing.

Which you can learn from 2nd attached file.

• 4. Re: Grand total not working when I had to make the measure as discrete

Thank you so much Shin!!!  I appreciate your time!

I'm almost there!

I got the totals but my Tittles are gone....I noticed you had six MIN(Number of records) vs I have three....was it to create the title?  I couldn't tell what you did with three that had shape assigned to it...sorry to be needy but stuff like this takes hours to figure out...

• 5. Re: Grand total not working when I had to make the measure as discrete

Please wait a while.  I will post it in a couple of hours.

It's not difficult, but a little bit troublesome....

Shin

• 6. Re: Grand total not working when I had to make the measure as discrete

Cool.  Thanks

• 7. Re: Grand total not working when I had to make the measure as discrete

Here you go.

• 8. Re: Grand total not working when I had to make the measure as discrete

You are awesome!!!  Thank you so much!

Purvi

• 9. Re: Grand total not working when I had to make the measure as discrete