Hi all,
I have the following Pivot with a filter on the Region and Slicers on the Year and Product Category:
<tbody>
</tbody>
I am trying to group the small values into a Region called "Other" using DAX, so I can create a pie chart with only the largest regions.
I tried the following DAX formula without success:
I cannot just add another column in my database as I use slicers to filter my Pivot, so I need the "Other" Region to be created on the fly, and not statically stored in the database.
Do you have any ideas of how I could perform this?
Thanks for your help!
I have the following Pivot with a filter on the Region and Slicers on the Year and Product Category:
Region | Sales | % of Sales |
Europe | 60,000 | 59.6% |
North America | 30,000 | 29.8% |
Asia | 10,000 | 9.9% |
South America | 500 | 0.5% |
Africa | 100 | 0.1% |
Grand Total | 100,000 | 100% |
<tbody>
</tbody>
I am trying to group the small values into a Region called "Other" using DAX, so I can create a pie chart with only the largest regions.
I tried the following DAX formula without success:
Code:
=IF(DimSales[% of Sales]<10%,"Other",DimRegion[Region])
I cannot just add another column in my database as I use slicers to filter my Pivot, so I need the "Other" Region to be created on the fly, and not statically stored in the database.
Do you have any ideas of how I could perform this?
Thanks for your help!