Hi 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.

When 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).

Bump. It seems like Tableau updates since 2015 have removed the ability to independently format grand totals. Does anyone have a workaround?

Pooja Gandhi

Best,

Simon

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

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

VERY 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

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

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

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

This is great!  Thanks very much. ☺

Cindy Schmelzer

Decision Support Analyst

Office of Fiscal Services

3391 Town Point Dr NW

Room 3950, MD 9110

Kennesaw, GA 30144

p: 470-578-3853<tel:4705783853>

e: cschmelz@kennesaw.edu<mailto:cschmelz@kennesaw.edu>