Forum Discussion
calculation with different groups
hello, for exemple,
I have 4 materials of the red type. One have a lifetime of 2 years and the 3 others have the life time of 3 :
and 3 materials of the blue type. all three have a lifetime of 2 years
| type | lifetime (year) | number of material by type and lifetime | total number of material by type |
| red | 2 | 1 | 4 |
| red | 3 | 3 | 4 |
| blue | 2 | 3 | 3 |
when the user filter by type red and blue, the mesure I want is the sum of all the "number of material by type and lifetime" divided by the "total number of material by type". But the first two rows of the last column are going to be counted 2 times instead of one. I want it to be counted only one time. The result of the mesure I want is : (1+3+3)/(4+3). Not (1+3+3)/(4+4+3)
This does not make a lot of sense. The information in your rightmost column is redundant, you can extract it from the number of material by type and lifetime column. The calculation you propose will always yield 1, so I am guessing you want something else
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |