I'm using pivot table a follows: * CustomerID as row dimension. * ActionCode as column dimension. * Cost as single measure. The measure including set analysis the master item: {<GroupName={'AAA'}, ActionCode={1, 2, 3, 4, ....}>}[CostEx]
I want to display in the pivot only the customers who have more than one code with cost (by meausre) greater than 10. *Edit* - I need to add a dimension next to each ID that shows the number of codes with cost above 10. This way the user will be able to filter/sort. But show only thise with more than one code above 10.
I tried several dimension (replaced CustomerID), It show me that the dimension is OK, but still shows 'Invalid Dimension' error. So I need your help.
You may need a second aggregation outside the count to make this behave as expected in the pivot, in which case you'd just aggregate based on CustomerID.
Note that your expression seems to be missing an actual aggregation, so it's hard to be sure what's happening.
I would tend to do the essential work within the data-model, for example by using range-min/max/sum/count() and/or aggregations and/or interrecord-functions like peek/previous in appropriated sorted resident-loads and/or querying the results of something like: sign(CodeField - 10). And on top may come n flag-logic which are then used as dimensions and/or conditions.
There are many possibilities - which might look a bit heavy for the questioned view but if there are more similar views respectively they would provide an added value it would be worth the efforts.
