Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to show a pivot table on a report in 3 different ways:
Current Week
YTD
Full Year
Can I do this in the report looping or do I need to create 3 separate pivot tables?
Thanks
You could loop through a field - if this field-selection could change your pivot properly maybe through conditions on fields and expressions it should be possible.
If you used macros you could select or change the properties how do you want.
But often is it the easiest and fastest way to use many specialized objects maybe hidden in a special print-sheet.
- Marcus