Forum Discussion
Calculated Table (No total in columns)
Im having this issue where im trying to aggregate some data into a calculated table. Im brining in customer name & and some measures for some columns.
The table is forming correctly without an issue, but when i construct a table on the report page columns are not showing a total at the bottom.
Measeures: Data Type: Decimal Number, Summarization:Sum, Format:Decimal number
DataFlow.Summary = SUMMARIZE('11_Accounts_Master','11_Accounts_Master'[GUID],'11_Accounts_Link'[Customer Name],
"FY20 A",
[FY20 A],
"FY21 A",
[FY21 A],
"FY21 E",
[FY21 E])
What do you think could be the issue?
Thank you & Kr
6 Replies
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
When you create a table visual on the report, you can enable and disable the total field.
Appreciate your Kudos.Hey Amit,
Thanks for helping out again.
Of course let me make a screenshot on another similar example. If you look below, you can see that Min is displaying the total at the bottom of the table and MAX is not, both have same exact setting terms of formatting. I dont understand why the behavior is diffrent.
Thank you & regards
