Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table and web view problem

Hi all!

I have created a pivot table.

But when i want to see all date (demension "date") for my first demension "1town" i scroll it and value of my first demension disappears.

pivot table.png

There it is ambiguously for which town  are this dates ans sales.

I want to display demesion value evertime  (show all time)  but i don't know how.

Any ideas?

2 Replies
Gysbert_Wassenaar

You can try adding 1town again as (calculated) dimension after date. Or you can change to using a straight table instead of a pivot table.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks for your answer,Gysbert, i have thought about it.