Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have this entry data
Month | DataType | Value1 | Value2 |
01 | R | 10 | 1 |
01 | O | 12 | 1 |
02 | R | 11 | 1 |
02 | O | 15 | 2 |
and I would like to obtain this result
Month | Total | 02 | 01 | ||||||
DataType | R | O | % | R | O | % | R | O | % |
Value1 | 21 | 27 | 77,78% | 11 | 15 | 73,33% | 10 | 12 | 83,33% |
Value2 | 2 | 3 | 66,67% | 1 | 2 | 50,00% | 1 | 1 | 100,00% |
where the rows Value1 and Value2 are expresions and the colum % is an aditional value of the dimension DataType
Value1 = sum(Value1) in % column sum({<DataType={'R'}>} Value1) / sum({<DataType={'O'}>} Value1)
Value2 = sum(Value2) in % column sum({<DataType={'R'}>} Value2) / sum({<DataType={'O'}>} Value2)
but the result obtained is this
Month | Total | 02 | 01 | ||
DataType | R | O | R | O | |
Value1 | 48 | 11 | 15 | 10 | 12 |
Value2 | 5 | 1 | 2 | 1 | 1 |
Any suggestions?
The partial sum will only show one sum. It can't split this per value of other dimensions. You can try creating an additional field that also contains Total as a value. See attached example.
The partial sum will only show one sum. It can't split this per value of other dimensions. You can try creating an additional field that also contains Total as a value. See attached example.
Gysbert, thank you very much for your answer. This is a way to solve one of my problems.