Display value of Min and Max date in Crosstab

building reports desktopintelligence
1

Hi,

I have a crosstab that has products along the rows and dates as cloumns in the total column i only want to display the value of the Min and Max dates e.g


              200403   200404   200405   200406
  Prod1     10           11          2             1
  Prod2     4            34          65           66
  Prod3     5            23           -              -

What I want to see in the total columns is


            Min         Max
  Prod1    10           1
  Prod2    4            66
  Prod3    5             -

I’ve tried using the following but it only shows the min values even if i replace the Min with Max

= Min(If =(Min(ForEach )) Then ) ForEach

Thanks in Advance

Minal :confused:

minal04 (BOB member since 2002-08-29)

2

The quickest solution would be to create the crosstab,
right click and place a min and a max calculation on the crosstab - so you get 2 new columns at the right hand side of the crosstab.

Then: View > Outline > Fold the Xtab horizontally … this will hide the body of the Xtab and leave just the min / max columns.

Reporter Bloke :uk: (BOB member since 2004-05-20)

3

this still doesn’t work as i get the max across all date by product.

:?

minal04 (BOB member since 2002-08-29)

4

You should be able to create a total Column and tweak the contextual formula so that it works.

=Min( in Body) in

Alternatively… if you have this already as a crosstab, insert the calculations for Min and Max to have this done automatically.

-RM

digpen :us: (BOB member since 2002-08-15)

5

If I use this formula

=Min( in Body) in (, )

This works for the MIN but if I replace it with a MAX it still gives me the MIN results

Why would it do this :confused:

minal04 (BOB member since 2002-08-29)

6

When I troubleshoot, I find it easier to create a new report with just those that I am dealing with. You can create your formulas there, or have BO do that. Once you have the values you want, turn them into Variables, and make sure that you set your Context Sensitivity on.

-RM

digpen :us: (BOB member since 2002-08-15)