Pivot chart: How to have total on the extreme right of the pivot
HI,
Similar to a pivot table in excel how can we have the total/subtotal on extreme right of the table. In Qlikview we can have the total/subtotal at the top or bottom of the row, but I want to have the total on extreme right as well.
If you pivot a dimension so that the values appear as columns, the total will appear to the far right. If your total is a sum of expressions you have to create an additional expression and use can use the column() function or expression labels to refer to the other expressions and add them up.
If you pivot a dimension so that the values appear as columns, the total will appear to the far right. If your total is a sum of expressions you have to create an additional expression and use can use the column() function or expression labels to refer to the other expressions and add them up.
