Query Calculations in Crosstab Headers/Rows Using the Same Measure

[fkli222]

Hi all!

Trying to create a cross tab report with the following...

Header:
Query Calculation: IF(Department in ('Finance','Human Resources') THEN(Value) ELSE (0)

Row:
Query Calculation: IF(Region in ('United States','Mexico') THEN(Value) ELSE (0)

Running this report gives me a blank value. If I take out either the Row or the Column, I do get results. Not sure if it is getting confused when mapping items and calling out a measure in the crosstab.

Basically what I am trying to do is map specific fields to be combined in both headers and rows and give me a value at an intersection point. '

Please let me know if this doesn't make sense and I can try to explain further.

Thanks!

[SpareTire]

Are you sure there exists a value in that intersection?

So your saying, if you remove the columns formula the row formula works and shows a value. If you remove the row formula, then the column formula works and shows a value?

Have you checked if your filtering rows/columns for zeros?