Query Item as Header of Column

[brassfid]

Hello all,

I have multiple items that are if then statements:

ex. If ([Version] = [Year])
Then ([Measure])
Else (0)

How do I get [Year] to show up as the header of the column?

Thanks!

David

[MFGF]

Hi,

Select the column header of the column, set the Source Type property to be "Report Expression", and set the Report Expression property to be your Year data item. You can only have one value in your column header using this method, though, so if you have multiple years in your data, your column heading will show the first one (I think). If you want anything different, let us know.

Regards,

MF.

[blom0344]

I would consider unlocking the list header and using a singleton that fetches the year value (Assuming [ version] is a single value).  I wouldn't be too surprised if no data is displayed when multiple values for year exist   :o

[MFGF]

Out of morbid curiosity, I tried it, and got the first year displayed as the column header. It wasn't formatted well, though :)