Hello,
I need to do a report to analize different data aggregation level in the same formula
Ex. - Sales detail of the customer with at least 1000 €/Year
- How many customer buy al least 2 article, how mutch do they invoice and their percentage to the total
I think that problem has the same solution
The invoice archive is the maximum detail lever
The dimensions are (for simplifies things): CUSTOMER_CODE,ARTICLE_CODE,DATE
I tryed that but it didn't work
sum(if(sum(TOTAL <CUSTOMER_CODE> VALUE)>1000,VALUE))
I can solve that using script level calculate field but I lose QV dinamic filter.
I can't filter for year or for month.
Thanks
