Hi All,
I have created macro which creates two pivot tables.
Row fields are same for both the pivot tables. Pt Cache is same for both the tables. Only change is in column field I apply filter for only one pivot item.
In one table, pivot item selected is "Hours" and rest all are made not visible. In second table,pivot item made visible is,"Hour" and other are made invisible.
But even if when pivot item ,"hour" is not in data source, it still creates table for ,"Hours". Basically it creates two pivots for , "Hours" pivot item.
How can I fix this one?
Requirement is if pivot item is not available in data source it should create blank pivot.
Code however works perfectly if both ," Hours" and ," Hour" are available in data source and it creates perfect two separate correct pivot tables.
Please help.
Regards,
Ishwar.
Bookmarks