7 Replies Latest reply on Sep 27, 2018 11:26 PM by Tushar More

# sum of amount by countd bank number

hi, I faced one problem of Tableau,

I would like the sum of amount by the countd bankcard,and sort by date and type, how can I make it?

• ###### 1. Re: sum of amount by countd bank number

Hi Sunny,

Is this what you want?

Tushar

• ###### 2. Re: sum of amount by countd bank number

Hi Tushar,

Thanks for your kindly help. However, I don't want to add the amount by the same bank card. That is, I just want the same bankcard number to add once. Can you help me with it?

• ###### 3. Re: sum of amount by countd bank number

Hello,

I modified the calculation in the attached workbook. Please check and let me know if that’s what you want. If not, please share a rough sketch of your expected result.

• ###### 4. Re: sum of amount by countd bank number

hi, Tushar,

I may not illustrate my problem clearly. I now need to SUM amount based on COUNTD of bank card. I think I need to create a field and use formula. But I don't know how to use it, sum[amount]/countd[bankcard] is not right, so how can I deal with it?

• ###### 5. Re: sum of amount by countd bank number

Sunny,

Apologies for not understanding your question. If you show your expected result by hand drawing or excel then we can solve it easily.  Meantime, I created few versions, please check and let me know if this what you have in mind.

or

~Tushar

1 of 1 people found this helpful
• ###### 6. Re: sum of amount by countd bank number

Thanks a lot Tushar, the version 1 is what I need. Could you tell me how to achieve it?

• ###### 7. Re: sum of amount by countd bank number

Please check the attached file sheet 2.

Let me know if you have any question.

~Tushar

2 of 2 people found this helpful