Formatting of One Row Pivot Table

[#1]

I have data that was loaded using the following LOAD Script

LOAD
Year(ExtractDate) AS Year
,SUM(Losses) AS Losses
RESIDENT lookupMasterServicer
WHERE ApplyMap('Map_Losses', Losses, 'False') <> 'True'
GROUP BY Year(ExtractDate);

So basically it is just a summary of Amounts by year... That I want to display in a pivot table that looks similar to the following

My problem is the formatting looks wacky for a one row pivoted table after I drag the year horizontally over the losses column. How can correct this to make it look a little more pleasing to the eye.

[stevedark · Accepted solution]

Hi there,

You may be better with a straight table and change it to be displayed Horizontal on the Presentation tab.

You can also play with hiding captions to make things look a bit tidier - particularly with small amounts of data. Experiment with other options on the presentation tab - for example you could suppress headers and create a new 'header' with a text box instead. This gives you more freedom of how to place stuff.

Good luck!

Steve

[#3]

Thank-you for the quick response...

I really like your answer. Just one last thing before I am completely satisfied... The auto total, how do I get rid of that?

[stevedark]

Hi there,

If you are now on a straight table go to the Expressions tab and select No Totals for each expression that you have. On a pivot totals are turned on and off for each dimension on the Presentation tab (Show partial sums).

Cheers,
Steve