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...
Appreciate if anyone help me asap...