Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a straight table on the front end want to filter the records by a dimension (based on max value of another value)
=if(FieldA = AGGR(max([FieldA]), [FieldB]), [FieldB])
and then suppress records when is null.
It works for most of the records but some of them isn't working
All the dimension fields will be null for these records (if I clicked suppress when value is null).
Any idea?
i did not understand your requirement, can you please elaborate preferably with examples?
Sample App/data would help a lot in helping out.
Sorry for my poor English.
I have a strange table with 3 dimension fields and some other expression fields
People | Branch Code | WorkOrder | Other expression fields |
A | 123 | 10 | |
A | 121 | 11 | |
B | 111 | 12 | |
C | 155 | 13 | |
C | 165 | 14 | |
C | 160 | 15 |
I want to show the records only with the max(workOrder) by people
People | Branch Code | WorkOrder | Other expression fields |
A | 121 | 11 | |
B | 111 | 12 | |
C | 160 | 15 |
I tried to modify the Branch code field as below
=if([WorkOrder] = AGGR(max([WorkOrder]), [People]), [Branch Code])
and click suppress value when is null.
Most records are ok but some records are not ok (e.g. missing the people c )
People | Branch Code | WorkOrder |
A | 121 | 11 |
B | 111 | 12 |
Hope I explained it clear enough this time
Use FirstSortedValue() like:
Dim : People
Exp1 : FirstSortedValue([Branch Code], - [Work Order])
Exp2 : Max( [Work Order])
use something like this and see
Dimension:
1. People
2. BranchCode
3. AGGR(max([WorkOrder]), [People]), [Branch Code])
Expressions
Still haven't sort it out yet. Any advice is welcomed.