How NOT TO TAKE into account dimension

[sculptorlv]

I have two dimension Client and Contract, and some Money values.

I have to decide, if Client is high money or low money ... like in right picture.

Then I need to add another dimension Contract for another calculations, but in Test expression I have to avoid it somehow.

Is it possible NOT TO TAKE into account selected dimension in expression?? (left picture)

Something like AGGR function, but without chosen dimension.

P.S.: based on my previous problem

[MK_QSL]

Provide more information please ... Your description is not giving proper idea what exactly you want !

[sunny_talwar]

You want to see Values in just one of those rows?

Try this:

Aggr(TestExpression, Client)

[sculptorlv]

I use this AGGR, but ...

If I have dimension Contract, it calculates based on Client AND on Contract - as the result different result

I need to get calculation based only on Client dimension (like on right picture), but I need to show dimension Contract in this table ... so for each contract should be taken calculation based on other dimension - Client (not Contract)

[gsbeaton]

Hi Ruslans,

Yes, it is possible to avoid the 'chosen dimension' using set analysis.  You would just have to so something like this

  Count({$<[ChosenDimension]=>} [Contract Number])

By using the '=' without a search parameter, you cancel that selection.

Hope that helps.  If not, please post more details on your problem.

Cheers

George

[sunny_talwar]

I think, like Manish mentioned, it would be easier to understand your issue if you are able to share a sample.

[jonathandienst · Accepted solution]

I think this is what you are after - use a qualified TOTAL, like

     Sum(TOTAL <Contract> Value)

This will ignore the Contract dimension.

[sculptorlv]

I think it is exactly what i wanted.

Thank you ... will test now.

Later..

This really works. My code is:

SUM(

TOTAL <Sales_Agent_Name> (

(if(Sale_Category = 5.2, Sale_Money, 0))))