6 Replies Latest reply on May 17, 2018 3:50 AM by Pankaj Nahar

# Grand Total working fine by column but not by row for one of two measures

I am working on a dashboard where in I wanted to see grand totals for two measures both by column wise & row wise.
As you can see in screenshot it works fine for 'Hours' measure but for '% Uptime' measure (which is aggregated calculated field) row wise grand total is blank whereas it returns value columnwise.

Just FYI,

% Uptime= If (ATTR([Logical Name]) = 'equip.deere.com' or ATTR([Logical Name]) = 'servicedelivery.deere.com') then (1 - ((Sum([Hours]) / ATTR([Month Days]*17*[No of Apps]))))

ELSE (1 - ((Sum([Hours]) / ATTR([Month Days]*24*[No of Apps])))) END

• ###### 1. Re: Grand Total working fine by column but not by row for one of two measures

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

PFA and help as soon as you can! Thank you.

• ###### 3. Re: Grand Total working fine by column but not by row for one of two measures

Good morning - see the attached

it returns this

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.

1 of 1 people found this helpful
• ###### 4. Re: Grand Total working fine by column but not by row for one of two measures

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.

• ###### 5. Re: Grand Total working fine by column but not by row for one of two measures

Thanks

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

Great! Thanks for the information.