Forum Discussion

venug20's avatar
venug20
Resolver I
7 years ago
Solved

Display state wise sales - exclude slicer selection

Hi everyone,   I have one table.    I want to display "sales", based on Slicer selection.   I have taken "State" into slicer. When choose state in slicer, show all state wise sales, except slic...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi venug20,

     

    Normal slicer not support exclude filter affect, you need to do some custom steps with a measure as filter to achieve this effect.
    Please take a look at attachment files if it works on your side.

     

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi venug20,

 

Normal slicer not support exclude filter affect, you need to do some custom steps with a measure as filter to achieve this effect.
Please take a look at attachment files if it works on your side.

 

Regards,
Xiaoxin Sheng

  • venug20's avatar
    venug20
    Resolver I
    7 years ago

    Hi Anonymous / Xiaoxin Sheng,

     

    Thank you very much for your reply. It's really great work. I am really apriciate your efforts.

     

    Please let me explain, what i am expecting output. Please see below snapshots...

     

    When i take "State" wise sales into visual, it show like below... (Total is : 1,37,15,444.31)

     

     

     

    when i exclude state as "Abia" using basic filter (Visual level), it show like below... (Total is : 1,37,14,380.19)

     

     

    You provided file shown state wise sales, when i exclude state as "Abia" from slicer. it show like below... (Total is : 9,08,620.78)

     

     

    here some state sales are missing, your approch is 100% correct.

     

    but State wise sales total giving wrong. Please suggest to is there any way to get correct output....

     

    Please help on this requirement..... 

     

    Once again thank you for your reply....

     

     

     

     

    • PattemManohar's avatar
      PattemManohar
      Community Champion
      7 years ago

      venug20 Please remove "Market" field from the second visual, then the counts will match as expected.

      • venug20's avatar
        venug20
        Resolver I
        7 years ago

        Thanks Anonymous it is working fine...

         

        Thanks PattemManohar. you suggestion is perfect...

         

         

        Anonymous

         

        Can you explain step by step, how it's working...