The method described here is likely suboptimal in many ways,
but maybe it can give some ideas.
For more ideas, here are some other threads discussing this subject:
The first two discuss putting the count in the title.
I think it will be difficult to put it into another sheet using the DecileCalc filter as is.
One of the suboptimal ideas presented in sheet Random Table 2 of the workbook
attached in the Forum thread is the use of parameters instead of the DecileCalcFilter.
This requires a separate setting for min and for max.
Then the records can by counted by:
WINDOW_SUM(iif([Decile Calc Net Sales]<=[DecMax] AND [Decile Calc Net Sales]>=[DecMin],1,0))
267753count.twbx 1.3 MB