i have this code wohois working perfectly with a standard pivot tabel, it count the number of visible item in a slicer
Range("g2") = ActiveWorkbook.SlicerCaches("Segment_CNP1").VisibleSlicerItems.Count
but since i use now a OLAP base pivottable the code do not work anymore.
is there another way to count the number of item selevt in a slicer base on an OLAP table (Powerpivotable) ?
Thank you for your help
Range("g2") = ActiveWorkbook.SlicerCaches("Segment_CNP1").VisibleSlicerItems.Count
but since i use now a OLAP base pivottable the code do not work anymore.
is there another way to count the number of item selevt in a slicer base on an OLAP table (Powerpivotable) ?
Thank you for your help