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

Purvi Ajmera Jul 25, 2016 2:41 PM

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!

Sample for Grand Total on Discrete.twbx 93.4 KB

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

Shinichiro Murakami Jul 25, 2016 6:17 PM (in response to Purvi Ajmera)
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,

Sample for Grand Total on Discrete_9.2.twbx 85.5 KB
Like Show 0 Likes(0)

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

Purvi Ajmera Jul 25, 2016 7:01 PM (in response to Shinichiro Murakami)

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
Like Show 0 Likes(0)

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

Shinichiro Murakami Jul 25, 2016 7:27 PM (in response to Purvi Ajmera)
Here is another way to achieve same thing.

Which you can learn from 2nd attached file.

multiple kpi.twbx 1.5 MB

Sample for Grand Total on Discrete_2_9.2.twbx 112.3 KB
Like Show 0 Likes(0)

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

Purvi Ajmera Jul 26, 2016 8:06 AM (in response to Shinichiro Murakami)

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...

thanks for your help
Like Show 0 Likes(0)

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

Shinichiro Murakami Jul 26, 2016 8:21 AM (in response to Purvi Ajmera)

Please wait a while. I will post it in a couple of hours.
It's not difficult, but a little bit troublesome....

Shin
Like Show 0 Likes(0)

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

Purvi Ajmera Jul 26, 2016 11:22 AM (in response to Shinichiro Murakami)

Cool. Thanks
Like Show 0 Likes(0)

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

Shinichiro Murakami Jul 26, 2016 12:18 PM (in response to Purvi Ajmera)

Here you go.
Like Show 0 Likes(0)

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

Purvi Ajmera Jul 26, 2016 2:30 PM (in response to Purvi Ajmera)

You are awesome!!! Thank you so much!

Purvi
Like Show 0 Likes(0)

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

Shinichiro Murakami Jul 26, 2016 3:01 PM (in response to Purvi Ajmera)
Like Show 0 Likes(0)

Actions