Forum Discussion

cstew68's avatar
cstew68
New Member
9 years ago

Profit and Revenue Report by Client - Multi Line Charts? Help!

BI Pros! 

 

I am a BI newb here so forgive me in advance. I am using BI on the web and trying to get a report together that looks like the one I show enclosed. I guess my question is... Is this possible? If so do I need desktop? 

I am enclosing a screenshot of my dataset in addition to a sample report. I am having a dickens of a time replicating this report in BI on the web version. Getting the clients broken out into groups and showing all clients selected with Prof and Revenue. 

 

Can someone provide some direction? What am I missing. Grouping? Do I need Pivot tables? Everything I try aggregates the data instead of seperating it out like I show below. 

 

 

Thanks in advance for your help! Hope this is not too ambigous.