set analysis

[Dolly123]

how to write last 6 month set analysis with top avg sales  with combined ?

[ift_isabelle]

Can you explain what you want to show?

The average sales of the last 6 months?
The top x clients sales of the last 6 months?
Something else?

[Dolly123]

Yes top 10 avg sales of last 6 month 

[ift_isabelle]

AVG({<Date = {">=Addmonths(monthstart(Today()),-6)"}, Client={"=Rank(sum({<Date = {">=Addmonths(monthstart(Today()),-6)"}>} Sales)<11"}>}Sales)

Something like this?

[khaoulaaa]

Hello @Dolly123 

I agree with @ift_isabelle  for the first part of the expression  

AVG({<Date = {">=Addmonths(monthstart(Today()),-6)"}>}Sales) you can also use max(Date) instead of today().

but for the rank I think you can use graphics properties

1- sort result like this : 

2-  limit the number of values displayed for the dimension :