Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table, with YEAR across the top (3 years so 3 columns), with the user being able to select from a list of available dimensions down the side.
I need the % to calculate for each individual column (year), as opposed to a percentage of the total.
Any ideas?
Then, the expression is: sum(Value)/sum(TOTAL <Year> Value)
As I can see, I think you are doing a percentage about the total, for example in the first cell is the percentage of the Stage 1 in 2015/6 about the total.
I think, you need only use the "function" TOTAL, for example: =sum(valueField)/sum(TOTAL valueField), isn't it?
Regards
nope - tried that with no success
Could you give me a dataset for testing?
I tested and it works for me, I'll show you
you can see the expressions at the top of the fields.
P.S. I'm sorry but I don't know how to upload a *.qvw file.
sorry - want i want is the percentage of stage for that year only: like this:
Then, the expression is: sum(Value)/sum(TOTAL <Year> Value)
Jose sir you are a legend.
thank you
You're welcome Phillip
just a thought - can this be done in Set analysis also?