Skip to Content
0
Former Member
Jul 01, 2009 at 09:55 PM

Cross-Tab - conditional suppression and formatting

938 Views

I have a cross-tab report of "widgets" sold. There are $10 widgets, $20 widgets, and $50 widgets. All widgets will always cost some round dollar amount, never anything like $10.99. My report shows weekly, month-to-date, and year-to-date sales for each widget denomination by both count and total amount by state. For example:

$10 $20 $50

count amount count amount count amount

New York

Week 5 $50 4 $80 1 $50

MTD

YTD

Delaware 1 $10

etc.

I also have totals by row, along with mark-up amounts (11% of gross sales amounts) and net sales (gross - mark-up). These last 3 columns are included in my dataset, not calculated in the cross-tab.

My problem is that I can't figure out how to do 2 things:

1. the count columns for mark-up and net will always be blank, so I want to suppress the "count" column header

2. I want to display the dollar amounts for those 2 columns with 2 decimal places, but the other amounts with no decimals.

Can this be done, and if so, how?

Thanks!

Phil