Forum Discussion

jpodBerlin's avatar
jpodBerlin
Advocate II
9 years ago
Solved

Interactive filtering treemap

Hello, my first post.   I am using two charts. One bar and one treemap chart. When filtering interactively by pressing one bar in the chart, the treemap's content adopts to this action.   The tr...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    That's weird. I can get it to work on my PC. I mean I can press the bar chart and get the filtering mechanism on the treemap.

     

    A pie chart is still a good solution nevertheless.

     

    Don't forget to accept a solution and give kudos.

     

     

     

     

jpodBerlin's avatar
jpodBerlin
Advocate II
9 years ago

Hello Martin,

 

thanks for the swift answer. I've tested it.

However, it shows an error (I try to translate in English). I hope I've transmitted the formula correctly.

 

"the function of type 'SUM' is used in a TRUE/FALSE expression, which serves as table filter expression. this is not allowed'

 

But the answer, it is generally out of box possible is helpful.

 

Matthias

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

jpodBerlin

 

I messed up a paranthesis. Try this:

 

Sum Value = IF(HASONEFILTER(Table[Category]);CALCULATE(SUM(Table[Value]);ALLEXCEPT(Table;Table[Category]));SUM(Table[Value]))

 

Let me know how it goes.