Want to add more than 9 dimensions in pivot table

[#1]

Hi All,

         I have 20 dimensions in my excel sheet. I used Pivot table Concept but it allows only 9 dimensions.Please help me how to add more dimensions in pivot table.

Thanks,

Shonasen

[tyagishaila]

You can try customized table method to show all 20 dimensions, but show max 9 at a time.

Customizable Straight Table

[Gysbert_Wassenaar]

A pivot table can have as many dimensions as you want. But each dimension you add will make the pivot table slower. I have no problem creating a pivot table with a dozen dimensions. Can you post a qlikview document that demonstrates the problem?

[#4]

I tried to use pivot table in Qlik Sense not in QlikView.

[Gysbert_Wassenaar]

Then you posted in the wrong forum. No problem, but it's why I assumed you're using QlikView. Please your question post in the Qlik Sense forums.

[#6]

Sorry and Thank u  Re: Congratulations ! Gysbert Wassenaar