-
1. Re: Grand total not working when I had to make the measure as discrete
Shinichiro MurakamiJul 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,
-
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
-
3. Re: Grand total not working when I had to make the measure as discrete
Shinichiro MurakamiJul 25, 2016 7:27 PM (in response to Purvi Ajmera)
-
multiple kpi.twbx 1.5 MB
-
-
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
-
5. Re: Grand total not working when I had to make the measure as discrete
Shinichiro MurakamiJul 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
-
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
-
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