Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
Have someone of You realized issue how to calculate different figures for each level of hierarchy? I dont know how to show one figures (I have already calculated) for the lowest level of hierarchy and another for higher level while number of levels are not fix. I have database like this
And I need to show for users only one value in Matrix and should looks like this:
But I am not able to show / calculate different figures for each levels => in case for example A2.1.1 or B1.1 is last level in hierarchy should include only values for posting items 1 and in case its not last lavel in hierarchy should include all values with all posting levels.
Thanks
Check out Matrix Measure Total Triple Threat Rock & Roll.
Hi,
This is working only if You have fix hierarchy and each level are fulfilled but I dont have fix hierarchy and some companies going up to level 6 and some only to level 4.
Think I find solution but I need to test it and I will let know the result soon.
Thanks a lot