How to display 'High' and 'Low' text in a Cross tab report?

[myshah789]

Hi Techies,
I have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'.
Please advice!

Regards,
Shah

[HalfBloodPrince]

You create a Query calculation for it.

If([Revenue] >10000000) then
('High')
else
('Low')
But what is the criteria to decide whether REVENUE IS High Or Low ?

[myshah789]

Hi,
The criteria is: If the Revenue is > 10000 then cross tab report should display as 'High' whereever it is in a seperate column else 'Low'.

But, as per your suggestion if we create a calculated item for this condition, then can we drag it into the measure? I mean, can we drag a query calculation or a calculated item inside the measure.

Please advice!

[HalfBloodPrince]

Add Revenue in Column not as default measure next to it add this calculated column.

[myshah789]

Hi, Thx for your reply,

Let me explain my question again.
The requirement is Product item should be dragged in "Rows", Region item in "Columns" and the Revenue item in 'Cells'. Now I have to add another item into the "Cells" which should display as a column in the report just beside the Revenue column and it should display 'High' and 'Low' based on the Revenue.

The 'High' and 'Low' column should be added just beside the Revenue column in the "Cells".
Hope it should explained my requirement.

Thanks again!

--Shah

[HalfBloodPrince]

Make Design Like This
Add Product In row, Then add Region In column. Then add Revenue in column Under Region. same way add High/Low Calculated column next to revenue Under Region.
Try and let me know.                         

[MFGF]

Hi, Thx for your reply,

Let me explain my question again.
The requirement is Product item should be dragged in "Rows", Region item in "Columns" and the Revenue item in 'Cells'. Now I have to add another item into the "Cells" which should display as a column in the report just beside the Revenue column and it should display 'High' and 'Low' based on the Revenue.

The 'High' and 'Low' column should be added just beside the Revenue column in the "Cells".
Hope it should explained my requirement.

Thanks again!

--Shah

The cells of a crosstab will only display numeric values by design. There are several techniques I have see on here to try to get descriptive values in the cells, but often they are clunky to implement.  If I remember correctly, Lynn posted on this topic a while ago - do a search on her posts to see what she suggested.

A much easier alternative would be to use conditional highlighting to set colours/fonts etc for the relevant high and low values in the cells, then add a couple of text items next to the crosstab to act as a legend - telling users what the colours mean (if it isn't obvious). Would this be an acceptable solution?

MF.

[HalfBloodPrince]

YES am Also Agree with MF.

[myshah789]

Hi MF and Prince,

Many many thanks for your quick response.

I'll implement it and let you know soon.

--Shah