Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a pivot table, which runs with two toggle button weekly and monthly. Currently when clicked on weekly button all the weeks can be viewed which looks more compact.
I need the table to be viewed with only 13 weeks when clicked on weekly button and then scroll on right to view the following week.
Is there any solution for this? Any suggestions would be appreciated.
Thanks in advance!
Just figured out a way, used vizlib pivot table and customised the column size setting from the property panel and it meets my requirement.
Unfortunately we can't control the width of pivot tables columns like that. At least not with the standard pivot table, perhaps it is possible with some third party extension.
Thanks for you response, I am aware of the width table can't be handled. Just thinking of a work around where only 13 weeks are selected by default.
Just figured out a way, used vizlib pivot table and customised the column size setting from the property panel and it meets my requirement.