I created a Pivot table with 6 columns A,B,C,D,E,F. It is grouped by column b,c,d and it has the column total of F based on the grouping. I was able to achieve it by Partial Sum on Column A. Now B,C,D columns are displayed and then column A is displayed. Is there any way I can make Column A as the first column along with grouping and total.
Also column F needs to move before column E. If I drag drop it it works in straight table and not in Pivot Table.
Can I achieve the same in Straight table.I want sub total of column F grouped by Column B,C,D. I can't do it in the LOAD as I am using the same columns differently across reports
I understand that you have A,B,C,D,E in Dimensions and F as an Expression. You can promote the columns as per your requirement on the dimensions tab accordingly columns will be place as first, second and so on.
You can obtain subtotals on any of the dimensions column from the Presentation Tab by selecting Partial Sum. You can have subtotals for A, B, C, D dimension.
To move F before E, you have to put both F and E in Expression and then you can promote F before E in expressions tab.
I am attaching the qvw and excel file I want Name as first column and Total to appear. This is GROUPEDBY first on PD, then ID, then CURR.. So total to appear based on these 3 columns. I did it in Pivot table, but if there is a way to do it in Straight table, I am fine with that also.
With straight table you can get totals only on one level (i.e. for the expression).
You can group by PD, ID and CURR but Name cannot be the first column in that case. You can understand that Pivot table first column is the outermost column for the group by clause. Next column will give sub group of first column and so on. This is how subtotals work for pivot table.
Yes Tripti, I understand. But the User needs this and I am trying to find out if there is any other way to do it. How about Dimensionality() , can that help. Thanks again
Thanks for helping. I fixed the problem in script part. I avoided Pivot table and used straight table instead with scripting handling partial sums. Thanks @Tripti Gupta
