Forum Discussion
Solved
Table
I have a table with columnns A through D. I need to find a way to sum the data from column D filtered by column C. Finally, if I take the column C out of the table, D still need to present the total results as filtered by column C.
I will try to make an example:
Column A. Column B. Column C. Column D
Event 1. Event 1. Tax Id 1. 4
Event 2. Event 2. Tax Id 2. 4
Event 3. Event 3. Tax Id 3. 5
Result I need
Column A. Column B. Column D
Event 1. Event 1. 4
Event 2. Event 2. 4
Event 3. Event 3. 5
I will try to make an example:
Column A. Column B. Column C. Column D
Event 1. Event 1. Tax Id 1. 4
Event 2. Event 2. Tax Id 2. 4
Event 3. Event 3. Tax Id 3. 5
Result I need
Column A. Column B. Column D
Event 1. Event 1. 4
Event 2. Event 2. 4
Event 3. Event 3. 5
Hi Josearce,
We can create a calculated table as below.
Table = SUMMARIZE(Table1,Table1[Column A],Table1[Column B],"D",CALCULATE(SUM(Table1[Column D]),VALUES(Table1[Column C])))
Regards,
Frank
1 Reply
Hi Josearce,
We can create a calculated table as below.
Table = SUMMARIZE(Table1,Table1[Column A],Table1[Column B],"D",CALCULATE(SUM(Table1[Column D]),VALUES(Table1[Column C])))
Regards,
Frank