-
1. Re: Grand Total working fine by column but not by row for one of two measures
Jyothisree Rayagiri May 16, 2018 2:38 AM (in response to Pankaj Nahar)Can you share your workbook with sample data
-
2. Re: Grand Total working fine by column but not by row for one of two measures
Pankaj Nahar May 16, 2018 5:12 AM (in response to Jyothisree Rayagiri)PFA and help as soon as you can! Thank you.
-
Dashboard.twbx 245.4 KB
-
-
3. Re: Grand Total working fine by column but not by row for one of two measures
Jim DehnerMay 16, 2018 5:38 AM (in response to Pankaj Nahar)
Good morning - see the attached
it returns this
I made 2 changes
first I changed the % total formula as shown and placed it on the detail shelf in place of the the percent field
second I changed you percent formula as shown
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
Dashboard_v10.2.twbx 230.1 KB
-
-
4. Re: Grand Total working fine by column but not by row for one of two measures
Pankaj Nahar May 17, 2018 12:18 AM (in response to Jim Dehner)Thank you so much Jim !
I just tried making the second change, mentioned above, in my workbook and it worked perfectly. I didn't have to add % Total calculation at all, to the workbook.
Can you please help me understand how did 'ATTR' changing to 'MIN' in % Uptime calculation made difference? This is great!
-
5. Re: Grand Total working fine by column but not by row for one of two measures
Jim DehnerMay 17, 2018 3:29 AM (in response to Pankaj Nahar)
Thanks
Glad to help out.
This is a case where you want the actual number to use in calculation - therefore use min(), Max()
The Attr() function is fine for the string field -
Also I avoid Attr() - it can't be used in LOD expressions and often I will pick up a calculation and drop it into an LOD only to find I have to remove the Attr()
Jim
-
6. Re: Grand Total working fine by column but not by row for one of two measures
Pankaj Nahar May 17, 2018 3:50 AM (in response to Jim Dehner)Great! Thanks for the information.
Follow up question -
Why would it have worked for column wise grand total calculation then? I mean how could '% Uptime' have values for grand total by column & just 'not by row'? Just Curious. Thanks in advance.