Using a Slider to select from a Pivot table

[#1]

Hello

I’ve got a pivot table which contains Customer and Order Date as Dimensions and Product and Cost as Dimensions. I want to be able to use a slider to filter the pivot based on the number of occasions the Customer appears. So for example if 6 is selected on the slider, all Customers who have an entry with 6 dates will be displayed.

Is anyone able to help – or offer an alternative to using a pivot to achieve the above?

Thanks in anticipation.

[antoniotiman · Accepted solution]

Hi Jim,

see Attachment.

If You want only =Count Date change '>=' to '=' in Calculated Dimension Customer

Regards,

Antonio

[#3]

Excellent Antonio, thanks for your quick response. Much appreciated

Jim