Skip to Content
0

SAP Lumira 1.30, Percentage Of

Nov 02, 2017 at 06:10 PM

73

avatar image
Former Member

Hi

I have created one Stacked Bar Chart and used Percentage Of Calculation for measure

There is a option to select Dimensions in which I need to apply Percentage, which is Ok and working good

But now I have scenario where I have to create Drill down custom hierarchy as a Dimension, and now Percentage of under measure calculation is not working

It seems like Percentage of does not work with custom hierarchy dimension

Can you please help me and let me know how i can apply Percentage of to custom hierarchy

let me know if we can do this task either sap lumira 1.30 or 2.0 discovery

Thanks

Deepak

10 |10000 characters needed characters left characters exceeded

What is your data source? Can you share screen shots so we can try to recreate it?

0
Former Member

I have attached file, Measure is not getting calculated properly when I drill down to product Line, it still take PBU as base Dimension

example.png

example.png (179.4 kB)
0
Former Member

Can anyone answer my above question

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Nov 08, 2017 at 04:43 PM
0

Deepak - I didn't get notified of your comments.

I tried it in Lumira 1.31.8 - see below:


percentag.jpg (134.4 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Tammy

Thanks for you reply / answer

In this scenario % is getting calculated at lower gain that is SIG ( Dashboarding, Reporting, BI plat etc)

we have drill down hierarchy (Speaker/SIG)

But I want if we are at Higher gain (Speaker) then Bar & percentage should be shown only for Speaker, and once we click on any speaker than it should go to Speaker/SIG level which you have shown

Initially Bar/ percentage will be calculated on higher gain that is Speaker while we click and go to lower gain SIG, percentage and bar will be calculated on SIG Level

Thanks & Regards

Deepak

0