Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My bar chart are without dimensions, Hence in the expression I want to aggregate based on distinct values for a particular dimension for e.g.
Current Expression:
Sum(Tender Values)
Requirement:
I want to aggregate Tender Values based on distinct values for Tender Lines.
May be like this:
Sum(Aggr([Tender Values], [Tender Lines]))
Or you can try one of these also:
Sum(Aggr(Only([Tender Values]), [Tender Lines]))
or
Sum(Aggr(Avg([Tender Values]), [Tender Lines]))
or
Sum(Aggr(Sum(DISTINCT [Tender Values]), [Tender Lines]))
or
Sum(Aggr(Min([Tender Values]), [Tender Lines]))
or
Sum(Aggr(Max([Tender Values]), [Tender Lines]))
If you mean that you would like to use an expression for each value of Tender Lines, then the best way is to use Tender Lines a a dimension. But assuming that there are a few, fixed values of Tender Lines, then you could use expressions of the form:
=Sum({<[Tender Lines] = {'first value'}>} [Tender Values])
=Sum({<[Tender Lines] = {'second value'}>} [Tender Values])
...