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!
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?