I have a table of data, an extract of which looks like this:
<tbody>
</tbody>
I want to produce a Pivot Table that looks like this:
<tbody>
</tbody>
Thans to help from an earlier thread, I am using the following DAX formula to return the value of the Birmingham office's sales, as Birmingham has the highest sales:
=MAXX ( VALUES ( Sales[Office] ), CALCULATE ( SUM ( Sales[Sales] ) ) )
Is there a DAX formula that will return the text string 'Birmingham', based on the fact this office has the highest sales, as established by the above formula?
Any help much appreciated.
Country | Product | Office | Sales |
UK | Shoes | Leeds | 100 |
UK | Shoes | Leeds | 100 |
UK | Shoes | Leeds | 150 |
UK | Shoes | London | 200 |
UK | Shoes | London | 340 |
UK | Shoes | London | 560 |
UK | Shoes | Birmingham | 800 |
UK | Shoes | Birmingham | 900 |
UK | Shoes | Birmingham | 2000 |
<tbody>
</tbody>
I want to produce a Pivot Table that looks like this:
Product | Highest Sales | Office |
Shoes | 3700 | Birmingham |
<tbody>
</tbody>
Thans to help from an earlier thread, I am using the following DAX formula to return the value of the Birmingham office's sales, as Birmingham has the highest sales:
=MAXX ( VALUES ( Sales[Office] ), CALCULATE ( SUM ( Sales[Sales] ) ) )
Is there a DAX formula that will return the text string 'Birmingham', based on the fact this office has the highest sales, as established by the above formula?
Any help much appreciated.