Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Creator
Creator

Alternate state inside measure

Hi all,

In a Dynamic table (Ad hoc reporting) I've created -

the user selects a store (green mark) , dimensions a measure (black)

And as a result-  only stores that have the same values as the store selected (green)  in these dimensions (FC, TENBIS in this case) , are shown in the table. (implemented with alternate states)

aheavy95_0-1697367034446.png

In one of my dimensions- Area, instead of showing restaurants with the exact number only, I want to show the ones that are in the range(of +-20) of the selected store's area. 

This is how the dimension field is implemented  (same for all). What should I add in order to achieve this? 

=Aggr( Only( {StoreComp1} BrutoArea), BrutoArea)

{StoreComp1} is the reference to the alternative state 

 Thanks

 

Labels (5)
0 Replies