Forum Discussion

amantawy001's avatar
amantawy001
New Member
5 years ago

Slicer help

I have a report where I should reflex a measure output on a slicer as follows

1- Engagement margin

EM (%) for Minimum Fee = ([Recorded Rev at 60% BR]-[TAC Cost])/[Recorded Rev at 60% BR]
2- Start point for slicer
Start Point TAC = 100*([EM (%) for Minimum Fee])
3-  Generated slicer values 
TEST TAC = GENERATESERIES([Start Point TAC], 100, 1)
 
The issue is the slicer minimum value does not change with the calculation for start point.
Any1 can help with this ?Trobleshoot

 

 

 

Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amantawy001 ,

     

    I don't quite understand. You want the silicer be affected by the measure value?

    Can show more details? It's better to share some sample data and expected result to us.

     

    Best Regards,

    Jay