How to calculate contribution in Revenue by non linked field based on user selection ?

[shekhar_analyti]

Hi All ,

How to calculate contribution in Revenue by non linked field based on user selection ?

• IF USER SELECTS VALUE 1 IN DROP DOWN THEN FROM Top_BU field Bode-Baumbach should be selected , and % of its contribution from total sales be calculated ... Likewise
• IF USER SELECTS VALUE 2 IN DROP DOWN THEN FROM Top_BU field Bode-Baumbach and Cremin Group should be selected ,
• IF USER SELECTS VALUE 3 IN DROP DOWN THEN FROM Top_BU field Bode-Baumbach,Cremin Group and Cummings should be selected
• Similarly for 4 first four should be selected ... and likewise

Please refer the attachment for detail .

Thanks & Regards

Shekar

[shekhar_analyti]

Top_BU is list of Business Unit arranged according to priority defined for Business Team ...  

[sunny_talwar]

But Top_BU is sorted in order of Text? Is it a coincidence that Top_BU is in the same order of the ascending order of text? This makes me uncomfortable... are you sure you are putting your requirement in the right way?

[shekhar_analyti]

Hi Sunny Bhai

Yeah Requirement is pretty similar to real time . And it is incidental that Top_BU is sorted , however in real time the data is not according to sorted order but according to priority set by Top level managements . I can see some BU starting with letter S on second and 3rd position in real time Data . Basic idea was the achieve or to enable the user to see % contribution by Top X business Unit ...

You can change the Top_BU order the way you want . I does not change requirement .

[shekhar_analyti]

SAMPLE

[sunny_talwar]

Are you able to create a field where you give the top_BU a ranking in the script based on what is decided by the top level management?

[shekhar_analyti]

No i have not done that . Actually management based on their own criteria concludes the Rank for BU . I dont have privy to that . They only share excel sheet where in the BU in first row assumed to Top BU . You may consider 1 st record in excel to have rank 1 , 2nd one as rank second and likewise . And these order changes in every quarter .
So basically position of BU in excel sheet determines their "Topness" , if i may call it so ...

If user selects 3 from drop down then first 3 BU should be taken in set and their respective revenue % should be calculated ..

[sunny_talwar]

Okay, which object are we calculating this in? What are the dimension?

[shekhar_analyti]

Hi Sunny Bhai ,

Apologies for late response .

And Dimensions to begin with will be year wise : something like year wise contribution of Top X (user selects value X from drop down)  Business Unit ..

Object as Straight table to begin with

Thanks & Regards

Shekar

[shekhar_analyti]

Sunny Bhai ... Can this be achieved now ?