Pivot table blank rows sort

[nareshthavidishetty]

Hi,

Below is the report which we have developed and we need to sort the market(Oklahoma) which are in blank in bottom of the report.

[adamdavi3s]

I'd advise sorting the dimension by some expression, without a qvw to work with its tricky to say what but in simplistic terms this is just sorted on the value of someotherdimension bb descending. However I suspect that your requirements are more complex than this in reality?

[Anonymous]

Hi Naresh,

Use following steps:

RightClickOnTable-->Properties-->Sort-->Sort all requires dimensions in numeric Value-->Descending Order

Thanks,