Combining measures in single expression

[nareshthavidishetty]

Hi,

How to bring 3 product sales in one expression.

Ex: i have 3 products like A,B,C

I have created a pivot table , in the expression in need overall sales like sales (A+B+C)

can anyone give the expression for this

[tamilarasu]

Hi Naresh,

Just write, Sum(Sales). What is your dimension.?

I assume that all you have Product as dimension and Sales filed as expression in pivot table.

[raghvendrasingh]

Hi Naresh,

Please provide complete requirement, What you actually want to see?

Regards,

Raghvendra

[Anonymous]

Is this you want??

Product          Sum(Sales)

A                        1400

B                         500

C                         600

[nareshthavidishetty]

ii need like sum(A+B+C) ie., over all sales

[Siva_Sankar]

PFA

[settu_periasamy]

Hi Naresh,

Try this..

=sum(TOTAL Sales)

you can include your dimension, if you want.. like

=Sum(TOTAL <Year> Sales)

[Anonymous]

You can try like:

sum(A)+sum(B)+sum(C) as TotalSales

[Mark_Little]

Hi,

SUM({Product={'A','B','C'}}Sales) Would sum the sales for Product A, B and C

Then

SUM({Product-={'A','B','C'}}Sales) Would sum the sales for all Products except A, B and C

Mark

[HirisH_V7]

Hi,

Marks expression helps you .

Thanks,

hirish