Skip to main content

Hi community,

 

i've created a filter to filter customers base on their total sales.

basically 3 buckets

 

<$50

between 50 and 500

more than $500

 

how do i count the number of customers thats showing in the view and reflect it in the title of the workbook ?

i tried using

 

{Fixed [Sales Filter] : Countd [Customer Name]}

 

which doesnt work as it says sales filter is a measure not a dimension?

 

any help would be appreciated.

7 answers
  1. Mar 4, 2020, 3:28 AM

    Hello Gavin,

     

    I attached the workbook with the LOD solution. See attached.

     

    Robert
0/9000