Hi,
In singleton I put data item which I want to count Measure rows in crosstab.
When I use the function: count([Quantity] for report)
Result gives me a different value from that which should give.
Where do you think I'm wrong?
Is there another way to count the rows in crosstab?
Thanks.
I would guess that your crosstab is at an aggregate level that shows 7 rows but that there are 48 detail rows that contribute to this aggregate level which is what your expression is counting.
Try doing a count distinct on one of the items in the crosstab that isn't being aggregated and is unique across all 7 rows.
Thanks for the advice, Greg.
I changed the function of 'count(distinct [Detail Target]for report)' , but the result is still incorrect (14)
I will mention that in Properties pane is set in the following manner ->Aggregate Function is 'Count' and Rollup Aggregate Function is 'Automatic'.
Thanks.
It looks to me like Detail Target is a measure that is being aggregated.
Try creating a new data item in your query that concatenates Account and Out of Target Metrics. This should provide you with an item that is not aggregated and is unique within the rows of your crosstab. Then do a count distinct on that item.