BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

[Webi 4.x] How to create variable to get sum of downstream objects


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
raul0002
Forum Member
Forum Member



Joined: 25 Mar 2019

Posts: 1



PostPosted: Mon Mar 25, 2019 11:01 am 
Post subject: How to create variable to get sum of downstream objects

Hello All,

So I have been struggling with this issue. I have a table with some IDs and the people they report to and their levels. I have attached the mockup of data. I want to create a variable that can get #of Direct Reports for these IDs. So for example - ID 1002 has IDs 1004,1005,1006 reporting to it and should have # of direct reports = 3. The ID that does not have other people reporting to them should have #of direct reports = 0.

I want another variable PL/IC that gives "PL" if #of direct reports >0 else "IC"

I want to create a bar chart same as in the attached excel file us
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0289 seconds using 17 queries. (SQL 0.0023 Parse 0.0009 Other 0.0258)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo