Hi everyone,
I have a Matrix that looks at sales over a chosen time frame buy customer, by year. I am trying to create total sales > slicer to allow users to set some minimum requirements. Initially I thought this was would be simple but filtering by sales only creates a range based on the largest single transaction and I cant use a total sales measure in the slicer.
It seems like I must be missing something simple but I'm defiantly missing it. Any suggestions?
I have a Matrix that looks at sales over a chosen time frame buy customer, by year. I am trying to create total sales > slicer to allow users to set some minimum requirements. Initially I thought this was would be simple but filtering by sales only creates a range based on the largest single transaction and I cant use a total sales measure in the slicer.
It seems like I must be missing something simple but I'm defiantly missing it. Any suggestions?
