Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Within an pivot table I want to calculate sums from one dimension based on several criteria you can see below.
Dimension3='A' | Dimension3='C' or 'B' | |
Dimension1 ='A' and Dimension2 = 'B' | SUM(Dimension4) | SUM(Dimension4) |
Dimension1 ='' | SUM(Dimension4) | SUM(Dimension4) |
Dimension1 ='D' | SUM(Dimension4) | SUM(Dimension4) |
The given input data could like shown below:
Dimension1 |
Dimension2 | Dimension3 | Dimension4 |
A | A | 10 | |
B | 10 | ||
C | B | 10 | |
C | C | 10 | |
A | B | A | 10 |
A | B | C | 10 |
How can I built such a table and how can I display a row filterred for one value of a dimension, even if this dimension does not take on this value?
Could you give an example of what you expect the resulting output to be?
Of course! Please see the "result" table below:
Dimension3='A' | Dimension3='C' or 'B' | |
Dimension1 ='A' and Dimension2 = 'B' | 10 | 10 |
DImension1 ='' | 0 | 10 |
For me it's not clear what do you trying to achieve. Means which raw-data have which values and should be lead to which results by which calculations and why? I have the impression that you want to associate the data within the UI. It will be possible in many cases but it's not recommended because it's much harder as doing the essential work in the data-model.
If a data-model is properly built you have just simple expressions like sum(Value) and the object-dimensions and the applied selections are showing automatically the right associations with the wanted results and views.
I don't understand your dimension headlines. What does "Dimension3='C' or 'B'" mean? I would like to see input table (raw data) and output table (expected result).