Format a drill down report out of pivot table

[benisma]

I have a "detail" report on one page of my workbook and a "totals" page with a pivot table for a quick refrence for all of the field personnel. The idea is for the pivot table to be looked at first, then the detail for further info if an issue is found. In the detail report, there are gross profit figures built into the query. I can format the spreadsheet to show percentages, but when you double click on the sales dollars in the pivot table report, the percentages show up like this .5423116598. I have multiplied the column in the query by 100 to create a two digit number on the left side of the decimal, but it changes the percentages and still leaves the rest of the numbers to the right. Not good. I have tried to write a little in the sql statement too, trying to turn that number into a decimal etc.. Any ideas?

 

[DaleWatson123321]

Try using the ROUND function instead of multiplying by 100 - i.e. =ROUND(cell address,2)

Hope this helps.

Regards, Dale Watson

 

[benisma]

I can do that in the worksheet, but then that gives 2 sets of numbers for the sales manager to look at in the drill down report. Can I take out the first set of numbers from the pivot table and just use the rounded #s? If so, how? I tried to reset what data my pivot table was using, but it wouldn't let me.

Thanks in advance!