Forum Discussion
Filtering columns in summarizecolumn
Hi
I'm trying to filter rows so that get one value.
The Bonus ($) is calculated by multiplying GL ($) by 0.005
I would like to show the table so that it shows this way
| Ref# | Quarter | Month | Sales ($) | GL ($) | Bonus ($) |
| 30243770-440 | 2021-Q4 | 2021-M11 | 9,53034.86 | 96,1190.86 | 4,805.9543 |
| 30243770-440 | 2021-Q4 | 2021-M12 | 8,156.00 | - | - |
Or maybe someone can suggest another way to display same info
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated table.
Summarize = SUMMARIZE('Table','Table'[Ref#],'Table'[Quarter],'Table'[Month],'Table'[Sales($)], "GL($)",IF(RIGHT('Table'[Month],2)="12",BLANK(),MAX('Table'[GL($)])), "Bounds($)",IF(RIGHT('Table'[Month],2)="12",BLANK(),MAX('Table'[Bouns($)])))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated table.
Summarize = SUMMARIZE('Table','Table'[Ref#],'Table'[Quarter],'Table'[Month],'Table'[Sales($)], "GL($)",IF(RIGHT('Table'[Month],2)="12",BLANK(),MAX('Table'[GL($)])), "Bounds($)",IF(RIGHT('Table'[Month],2)="12",BLANK(),MAX('Table'[Bouns($)])))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly