I have a cross tab that looks like the following:
                            AN BN CN DN
Current Inventory   10 12 14 16
Adequate Invent   

I just added the row for adequate inventory.
the columns AN, BN, CN and DN are
Column #1 Name: @ABORH (string)

Im trying to define what goes in the Adequate Invent row under the AN, BN, CN, DN columns. The value for adequate inventory is a parameter entered variable. Ideally I think I could say...

If column header ="AN" then let Adequate Inventory first column = the parameter entered variable.

I however have absolutely no idea how to identify the column for each situation and or assign the parameter entered value.

any help would be greatly appreciated.....



Edited by cbaldwin - 23 Oct 2014 at 4:00am

I want to display the adequate inventory in every column AN, BN, CN, DN etc.

I want to display the adequate inventory in my cross tab.
For each of the blood types AN,Bn ETC

My intention is to later display the difference between current inventory and adequate inventory in a subsequent row.