Sorry man, too much information for me on the post you sent me, I am newbie in Tableau so really don't know where to look. I need some easier explanation if it's possible.
Thanks for the reply!
Tableau doesn't calculate the total last. It calculates it first and the applies the formula. So in your case it is summing the values first and then taking the absolute value of the sum. Since this is already positive it's the exact same value as your previous column.
Yeap, I understand what Tableau does, but I need a solution for that. As I told in previous post, I would appreciate it any easier explanation than to read a whole post as I am beginner in Tableau and don't understand a bunch of explanation from the topic you sent me.
Can you post the packaged workbook you are working on?
No, I can't because I am connected on company's database which requires permission. If you have any of your example it would be great, as I don't have anything.
Thank you very much for help!
I'm just trying to figure out what your formulas in your calculated fields look like so I can figure out where the problem is happening and how to fix it.
You need to understand it's going to be really difficult for Kat to help you without you providing a sample of your data. It doesn't have to be the exact data, but it should be easy enough for you to provide a sample using the same column names etc in Tableau, and create a Tableau Packaged Workbook. Please read the 'New to the community - Getting Started' section here, there's some great suggested specifically this - Anonymize your Tableau Package Data for Sharing
I understand you're also new to the product, so you might need to take a step back and master the basics before you get too deep in the advanced concepts! Have you had a chance to complete the free training online? Tableau Training and Tutorials
Ok, I'll try to explain you.
* DIFF = Current Week ( Week 25, 2016) - Forecast (Week 25, 2016) ; "Current Week" is company's database, "Forecast" is my imported Excel file.
* % Error = DIFF / Current Week
* ABS Diff = abs(DIFF)
It wouldn't be the same if I create my own example of this as I think it's a crucial for this matter that I have 2 different database sources.
As Tom mentioned, the primary problem here is that nobody will be able to help unless they can see your work. The links shared discuss the reason why your problem is occuring, of that I'm sure. However, without an example, its very difficult to help out.
That being said, nearly any scenario can be mocked-up/replicated with sample data. Below are two sepaare videos I would suggest if you have questions on how to create a mock-up workbook. All you'll need is a small # of records from each source, with any sensitive info removed -- and you can copy and paste your data from Tableau to Excel in order to do that. It sounds daunting, but once you figure it out, its very simple to mock up a sample workbook -- and this will enable you to get the most from these Forum volunteers.
It appears you have some great helpers trying to contribute here -- so if you can do a bit of leg work in creating an example scenario, you will get the help you need here on the Forums.
Best of luck!
Here we go again.
e.g. I have column A and B. Column C is calculated field with formula C=A-B
Now I need column D, which is D= ABS(C)
And finally need to see Grand Total. When I check show Column Grand Total, I don't get the correct Total. It gives me the same one as in Column C.
I have watched this video and after Copy data in Excel I have 423 Headers there. I don't know what I need for this purpose.
Really, if you don't have solution for me, it's OK, I am not mad but trying to figure out how this Tableau is so stupid!!!!!!!!!
This is not the type of response we're used to seeing.
Keep in mind that EVERY person on this thread is able to help you, and they are volunteering their time to do so -- but your descriptions are not enough to go on. We need to see the data and what you've done. This is not Tech Support, and if it was, we'd still need example data and a workbook to be able to help.
Also, Tableau is far from stupid from where I sit -- there is a logic to every working piece of the software.
I'm sorry learning is frustrating -- but believe me, there's a reason the totals don't match what you expect, and the reasons are explained in the links provided above.
Let us know how we are supposed to help.
I lost 2 days to find solution just for regular "Grand Total". I can't believe that this is so huge problem in Tableau.