6 Replies Latest reply on Feb 9, 2019 1:43 PM by Eric Liu

# How to calculate on selected month across years

Hi everyone,

I tried to sum the value on selected month across years and show the result in bar chart, but the result is not I want. Can anyone help me? Thank you.

Here is my problem: I created a calculation field to filter out some value that I need, and I want to sum them and show in a bar chat, but after I use bar chart, it will give me the total value from December, not the sum of value that I selected by using calculation field.

Here are the number that I want to sum:

The calculation field that I use:

But after I use bar chart, it will show me the total value from December not the sum of what I selected:

The number that I want should be 0.5107 instead of 0.4852.

Any way can figure this out? Thank you.

• ###### 2. Re: How to calculate on selected month across years

Good morning Eric

Could be a lot of things and we would be glad to help out but would need to see your TWBX workbook with the data

Jim

• ###### 3. Re: How to calculate on selected month across years

Deepak,

I just upload the workbook file, thank you.

• ###### 4. Re: How to calculate on selected month across years

Jim,

I just upload the workbook file with the data, thank you.

• ###### 5. Re: How to calculate on selected month across years

Ok

Here is what is going on -

you have an order of operation issue - table calculations (and lookup is a table calc) are at the bottom of the order of operation - done last -- Grand Total from the analytics tab are done before the table calcualtions

so when you use grand total on that calculation the only choice is Automatic  which means the formula is applied

now getting the total in that formula is problematic - if you can convert the look up to some other type of calculation would be one way - be to use some other table function like window-sum to get the total

which you can convert to this by hiding rows then bringing it to a dashboard and combining it with the other table

sorry but that what is happening

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 6. Re: How to calculate on selected month across years

Jim,

Thanks for your help, but the total value of the column should be 0.5107 instead of 0.5310.

At the same time, if I put them into the histogram chart, the result does not show the number that I want.