Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have the following (simplified) data model, where the blanks in DimB are NULL values :
The business requirement is to display the following chart with :
- Dimensions :
- DimA (lines)
- DimB (columns)
- Measures :
- Result (sum of Ind where DimB isn't null)
- TotalResult (sum of Ind whether DimB is null or not)
I am having a hard time calculating TotalResult, because I need to include NULL values without displaying an extra column for DimB (which was what I obtained when replacing NULL values with a blank in the script, and the users won't accept it).
I would be grateful for any help you could provide, please don't hesitate to ask for more details if my example isn't explicit enough.
Best regards,
Fabio
How do we know which null is associated with which value of DimB? Do they always load together (just like in your example)?
Hello Sunny,
You're right the example is wrong, I'm going to correct it.