How is a "% of total column" done in a pivot table?
I know how to do this using a straight table, but we need a pivot table.
The 1st column will be Product family,
the 2nd column will be Sum(Sales) and
the 3rd column will be % of total Sales.
Sorry for my late response.
And first of all thanks for the help, but when i paste your syntax in my QVW file
it gives me an error:
=sum([Totaal v/h Jaar]) / sum(TOTAL [Totaal v/h Jaar])
It says that the Fieldname is not correct.
But it is correct!
are you sure that you're not using the Label instead of the Field name as in the file you attached earlier? Try and open the Edit Expression dialog, and select the field you want to use in the drop-down list furthest down on the dialog, and hit the paste button where you want it to go.
Yes i'm sure it is not in the label:
the label says : 'Aandeel in portefeuille '
I cannot select the fields, because it is already an expression.
I can type in the beginning of the expression and intellisense does the rest...
so i know it is the correct way to write the variable... because it is case sensitive