Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can any suggest this scenario.
I have a pivot table Country, Fruits and Amount. Here first I have to show first 5 fruits for each country .Second, countries like SG and UK doest have 5 fruits (3 and 4 resp) here I have to show blank field with no amount (see attached image)
(See attached QVW and Excel input).
Regards,
Tom
As some countries don't have 5 fruits, you have to first link all fruits to all countries in script level with 0 sale or qty.
After this you can use Rank function to display them as per your requirements.