Forum Discussion

LucianaDomene's avatar
LucianaDomene
Frequent Visitor
9 years ago

Slicer

Hello,

 

I need some help to change the value when I click at a slicer.

There are two slicers. When I click at one item in the first slicer, the second will be filtered, and also all the reports of my page. 

If there is nothing selected at the second slicers, all the reports will show me the Sum of all them. I need to clear those values and put them equal 0. 

I try to creat a new column and calculate something like this: IF (Column = "X";0;Sum(Metric)), but didn't work, because the "Sum(Metric)" won't worry about that column anymore, so everything that I click at that slicer, won't filter anymore, it only shows the sum of everything. And I want to show 0 at only one item of that slicer, the other ones need to keep filtering.

 

Summing up, if I click at one item at the first slicer, and no item at the secod slicer, I don't want to sum, I want to show 0.

 

I don't know if I being clear.

Can someone help me.

 

 

1 Reply

  • Vvelarde's avatar
    Vvelarde
    Community Champion

    LucianaDomene

     

    Hi, It's no clear.

     

    Can you post a Screen Capture or a diagram of what you want.

     

    Thanks

     

    Victor

    Lima - Peru