Sum by catogary

[techvarun]

I have a staraight table with the following fields and i need to display the difference of

sum(totalamaunt) where catogay cost   and

sum(totalamount) where catogary Payable

Thanks  in advance

[kaushiknsolanki]

Hi,

     Remove the dimension Category and add this expressions.

     1. Sum({<Category = {"Costs"}>}TotalAMount)

     2. Sum({<Category = {"Payable"}>}TotalAMount)

     3. Column(1) - Column(2)

Regards,

Kaushik Solanki

[techvarun]

Hi Kaushik Solanki,

                           It Works here is my final Script

                      =(Sum({<Category={'Costs'}>} [Total (Amount)]) - Sum({<Category={'Revenue'}>} [Total (Amount)]))

Regards

[techvarun]

One more question what if i need to add one more condition like the month should be may?

Regards

[kaushiknsolanki]

HI,

     Then it will be something like this.

      Sum({<Category = {"Costs"},Month = {"May"}>}TotalAMount)

Regards,

Kaushik Solanki