sum with condition

[#1]

Hello Friends, I am working on bar chart. I have one problem. In Demention I am using column A. In Expression i want sum of column B but distinct of column C. Can any one help me in this? Thank you. Dipak

[salto]

Hi Dipak,

I do not understand what do you want to sum on column C. Can you provide more details? Thank you!

[#3]

Hello, Thanks for reply. Actually I want sum of columns B (salary). But i want this sum by distinct of column C (Employee ID - repeatative in table). I can't add this ColumnsC in dimention because i am already using column A in dimention. I hope this will help you. Thanks

[salto]

Hi again Dipak,

     can ypu please upload an example of what you have and what you want to achieve? An image or Excel chart would be enough.

     Thanks.

[#5]

Hi,

     can you please tell us what value you have in columnA?

    Otherwise if i understand correctly so try this in load script:

Temp:

Load

     *

From Table;

Final:

Load

     columnA,

     columnC,

     Sum(columnB) as TotalSum

Resident Temp

Group By ColumnA, ColumnC;

Then you can use TotalSum field in your expression with columnA  but the result will show in chart according to dimension field only.

Hope this helps you.

Thanks,

Ashutosh