First 5 values in Pivot Table and insert blank values

[thomas_skariah]

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

[MK_QSL]

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.