I have this basic pivot table. http://screencast.com/t/yf7BqnoQ9p. Right now it is cut by day but users want all of these reports to quickly toggle by day or month. I can add month but then we have to expand again by day. I don't really want to copy all the reports and change the day to a month. Any ideas on how to do this easily?
Go to the Properties window of the object. In the Dimensions tab, click on the "Edit Groups..." button and then click "New". Name the dimension group and add the dimensions you want included in the group. Once you've created the group and click 'OK' a couple times, don't forget to add the group to the object dimensions.
You can use Cyclic Group as Dimension that contains Day and Month Fields. By using Cyclic group you can change the Dimension on clicking the Cyclic Group icon.
If you want to drill through from Month to Day(Days with in the selected Month) then you can use the Drill down group.
I have done the expressions where I tick the relative and then group them. Then the little arrow shows up where I can rotate through. But how do I do that for dimensions?
Go to the Properties window of the object. In the Dimensions tab, click on the "Edit Groups..." button and then click "New". Name the dimension group and add the dimensions you want included in the group. Once you've created the group and click 'OK' a couple times, don't forget to add the group to the object dimensions.
