Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a crosstab. Using a Chart object right now. I have a dimension of products. I want to show the selected weeks across the top. Ranging from 1 to 53. I would like to add a total at the bottom of the dimension and a total accross summing up all the selected weeks. Not sure how to just show the selected weeks then sum them up giving me a total column.
Create a new chart and choose the Pivot Table as chart type. Add your products field as the first dimension and your weeks field as second dimension. Also add an expression that calculates something, for example sum(Sales). On the Presentation tab of the properties screen check the Partial Sums option for both dimensions. Under Subtotals you can choose if you want subtotals at the top or bottom (for a row dimension that means left or right). You may want to check the option Always Fully Expanded too. The weeks field will be the second column, so you'll have to drag it to above the expression column. This can be a bit tricky. When you see a horizontal blue arrow appear you can let go and the weeks field should be in the right place.
Create a new chart and choose the Pivot Table as chart type. Add your products field as the first dimension and your weeks field as second dimension. Also add an expression that calculates something, for example sum(Sales). On the Presentation tab of the properties screen check the Partial Sums option for both dimensions. Under Subtotals you can choose if you want subtotals at the top or bottom (for a row dimension that means left or right). You may want to check the option Always Fully Expanded too. The weeks field will be the second column, so you'll have to drag it to above the expression column. This can be a bit tricky. When you see a horizontal blue arrow appear you can let go and the weeks field should be in the right place.
Thank you, it's exactly what i needed.