Calculated Dimension

[#1]

Hi all,

I have data in two dimensions as below.

Doc Type-------------------- Amount

INV                              2313

INV                           234123

DN                              (2321)

INV                              1123

DN                              (123)

I want to take INV sums in one column and DN sums in other column and then Gross Profit (Calculated Dimension) in third column.

Please advise.

BR,

SAK

[sreenivas]

Hi

PFA of the File .

[#3]

Hi

for first expression

sum(if(Doc Type='INV',Amount))

2nd expression

sum(if(Doc Type='DN',Amount))

[kaushiknsolanki]

Hi,

     Try to create a straight chart with following expression.

     Dont need to have dimention in your case.

     1. Sum({<Doc_Type = {"INV"}>}Amount)

     2. Sum({<Doc_Type = {"DN"}>}Amount)

     3. column(1) - column(2)   for gross profit.

               or else

Sum({<Doc_Type = {"INV"}>}Amount) -

Sum({<Doc_Type = {"DN"}>}Amount)

Regards,

Kaushik Solanki

[sushil353]

Hi,

Is it what you are looking for.

Please find the attached file

HTH

Sushil