I have used first sorted function to find out first sales of month for a particular region/state, In Pivot chart I need to add each state value( result of : firstsortedvalue(Sales, Txn_Dt)) to the country level and continent level or few other dimensions.
When I try the following expression, it is resulting Null
It would be great if any could share your thoughts if you aware of such scenarios how to handle them.
Re: How to use sum and first sorted value together
Hi, i noted in your expression one bracket is missing: sum(FirstSortedValue(Sales,Txn_Dt) ) anyway how does your pivot chart looks like and what's your expected result? could you share an example with data?