Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I want to calculate the% of my turnover by product family on the total turnover.
I have 3 dimensions : nomenclature 1 / nomenclature 2 / nomenclature 3
- the% of the nomenclature number 1 s / total digit => OK
- the% of the nomenclature number 2 s / total nomenclature 1 => NOT OK
- the% of the nomenclature number 3 s / total nomenclature 2 => OK
I do not understand why 2nd is not working.
Scripts used :
If (dimensionality () = ('1'),
Sum ([PV HT]) / sum (TOTAL [PV HT]),
If (dimensionality () = ('2'),
Sum ([PV HT]) / sum (TOTAL <[Nomenclature 1]> [PV HT]),
If (dimensionality () = ('3'),
Sum ([PV HT]) / sum (TOTAL <[Nomenclature 2]> [PV HT])
))))
Thank you for your help
Would you be able to share a sample to show the issue?
Can you create a new expression
Sum(TOTAL <[Nomenclature 1]> [PV HT])
What value do you get here?
I get the total of "CA HT 2017": 202733 euros
It's weird ...
So right now you are getting 973/202733, whereas you want 973/10528? Is that right?
That's right
Is BAGAGERIE part of [Nomenclature 1]?
No, it is part of "Nomenclature 2"
Can you try this for dimensionality() = 2
Sum([PV HT]) / sum (TOTAL <[Nomenclature 1], [Nomenclature 2]> [PV HT])