Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Add Sumif values from a different table based on slicer selection

Hi,   I would like to fulfil a column with a sumif of values from a different table but with a filter from a slicer.   Let’s give the example: One table has a list of items with two columns (it...
Need Help
  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    3 years ago

    Anonymous 

    Hi,

    Right click the Item then tick show items with no data.

    Please accept this as solution if this helped to solve your problem.

    Thank you

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Dinesh,

 

Thanks, but I need keep the other items in the list with zero values.

 

Many Thanks

Nuno Paixão

 

Dinesh_Suranga's avatar
Dinesh_Suranga
Continued Contributor
3 years ago

Anonymous 

Hi,

Right click the Item then tick show items with no data.

Please accept this as solution if this helped to solve your problem.

Thank you