-
1. Re: Different number format for grand total
pooja.gandhi Sep 3, 2015 5:56 AM (in response to Frederik Leth)3 of 4 people found this helpfulHi Frederik,
So if you right click on any number in your measure in the view (like where I have shown an arrow) and click format, another pane opens in the left hand side. Click on the little on the fields and select your measure, in myc ase it was sum(quantity). Then in the grand totals area like highlighted below, chose a number format just for the grand totals.
Now you will see that all values are without a decimal point and only the grand totals have one decimal point.
-
2. Re: Different number format for grand total
PREETHAM SRINIVASAN Sep 15, 2018 12:05 AM (in response to pooja.gandhi)1 of 1 people found this helpfulWhen I choose the field from the "Fields" dropdown in your screenshot, I can see only one option under "Pane"(shown in my screenshot). I don't have a "Grand total" section there. When I change the number format there, it is affecting the entire table (actual value as well as the sub totals and grand totals).
-
3. Re: Different number format for grand total
Simon Zhang Sep 17, 2018 2:06 PM (in response to PREETHAM SRINIVASAN)Bump. It seems like Tableau updates since 2015 have removed the ability to independently format grand totals. Does anyone have a workaround?
Best,
Simon
-
4. Re: Different number format for grand total
Peter Fakan Sep 17, 2018 3:22 PM (in response to Simon Zhang)Hi Simon,
Yeah but its long... http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-1/ There's 3 parts to the blog series.
HTH
Peter
-
5. Re: Different number format for grand total
Simon Zhang Sep 18, 2018 1:03 PM (in response to Peter Fakan)Peter,
I reviewed all 3 parts and unfortunately it doesn't solve the issue I'm having. Part 1 covers hacking the solution with two separate pages which is unfeasible for me because the # of rows I need to display necessitates scrolling and I can't synchronize the scrolling for the two separate page solution.
Part 2 deals with having a custom calculation for grand total which is part of my implementation, but doesn't solve the formatting issue, & part 3 deals with duplicating the data via custom sql which isn't feasible due to the scale of data.
I've attached a workbook--I'm hoping you can have a look to see what I'm looking to achieve. I've also attached a SS below: Thank you in advance for your time.
Where i'm running into issues is where I'm displaying currency as well as unit measures in the same page. I'm not able to get a consistent format in the grand total column which I've renamed "WoW % Difference." You can see how it gets aggravating when you are displaying revenue in the millions and have to include 2 decimal places in the number formatting to get 2 decimal places in the % difference column. If I want to display a "$" for the measurement, the same "$" gets appended to the WoW % Difference cell.
Is there anyway I can have the number formatting set on a different granularity at the row level for the grand total? Tableau used to offer the ability to have independent number formatting for the grand total (per the earlier messages in the thread) but now it's done away with.
Please advise!
Best,
Simon
-
6. Re: Different number format for grand total
Shinichiro MurakamiSep 18, 2018 4:47 PM (in response to Simon Zhang)
1 of 1 people found this helpfulVERY VERY troublesome.
Only one way I know of.
Duplicate data.
Used simple filed instead of your complicated calc.
Put placeholder for three field respectively ,and here is a trick of placeholder.
Educational Brain Teaser ==> Answer : Colorful Conditional Format
Thanks,
Shin
-
7. Re: Different number format for grand total
Simon Zhang Sep 18, 2018 4:46 PM (in response to Shinichiro Murakami)Shinichiro,
I don't know what to say.. thank you for taking the time to write out such a detailed set of instructions. You are appreciated.
I'm going to give it a try and see how the performance is given our x00B + data set.
Best,
Simon
-
8. Re: Different number format for grand total
Shinichiro MurakamiSep 18, 2018 4:51 PM (in response to Simon Zhang)
It's less than half of detail. I cannot describe all here, it's too much.
You should spend not-short time to digest them.
Anyways, if this helped, please mark my answer as correct to close the thread, not from inbox but from original post.
Thanks,
Shin
-
9. Re: Different number format for grand total
Simon Zhang Sep 18, 2018 5:12 PM (in response to Shinichiro Murakami)Shin,
Unfortunately I am not the original poster. I've reposted my question and mentioned you. Please respond with a link to your reply here or something else and I will mark it as the correct answer.
Best,
Simon