Sum by Dimension Show Hide

[Senor_Dai]

HI,

I have a dimension called 'User' and an expression Sum(Daily Sales).

I would like to show a text object if any User has a daily sales amount of over 20.

IF anyone can help with the  correct show/hide expression please I'd be very grateful.  

Many thanks, 

Dai

[MayilVahanan]

HI

Try like below

=Count({<User={"=Sum(DailySales)>0"}>}Distinct User)

[Senor_Dai]

Hi @MayilVahanan ,

Thanks for the reply.  If I wanted to add a date to this eg, only for today, would the expression be

=Count({<User={"=Sum(DailySales)>0"}, Sale_Date={'Today()'}>}Distinct User)

Also, can you explain how this ensures that only sales over 20 will cause the obejct to display or do I need to add it the expression:

=Count({<User={"=Sum(DailySales)>0"}, Sale_Date={'Today()'}>}Distinct User)>20

[MayilVahanan]

Hi 

Try like below in the object to display 

=Count({<User={"=Sum({<Sale_Date= {'$(=Date(Today()))'}>}DailySales)>20"}>}Distinct User)

,  for understanding, you can try like below also.

=if(Count({<User={"=Sum({<Sale_Date= {'$(=Date(Today()))'}>}DailySales)>20"}>}Distinct User) > 1, 1, 0)

[yangkuki]

application useful word unscrambler