Forum Discussion

eaj's avatar
eaj
Helper I
2 years ago
Solved

Creating a Report Page with Department Comparison Using a Slider

I'm working on setting up a report page where users can select specific departments to compare against the rest. The idea is to use a slicer to pick certain departments, which would then be grouped i...
Need Help
  • raji_n's avatar
    raji_n
    2 years ago

    eaj you can use a measure to return the values instead of 1 or 0 and get the totals

     

eaj's avatar
eaj
Helper I
2 years ago

Thanks, this might be my lack of experience talking, but if it is a measure, how do I get lets say total revenue for group 1 and 2. I can't filter on measures, right?

 Doesn't it have to be some calculated column in my main department table?

raji_n's avatar
raji_n
Resolver II
2 years ago

eaj you can use a measure to return the values instead of 1 or 0 and get the totals

 

  • eaj's avatar
    eaj
    Helper I
    2 years ago

    That is very clever, didn't think of that. Thanks!