Hi everyone,
we need to create a top nth value using calculated field from below table:
| Offer Name | Sales |
|---|
| OfferName1 | 10 |
| OfferName2 | 40 |
| OfferName3 | 30 |
| OfferName4 | 35 |
| OfferName5 | 25 |
we are looking for the report something like below:
| Top 4 OfferName (No need to have a Offername here its just an individual Measure) | 25 |
| Top 3 OfferName (No need to have a Offername here its just an individual Measure) | 30 |
Please help me to acheive this...
