on 07-21-2014 2:31 PM
I created a report with 8 data fields; I added a 9th column and included a formula that provides a 'status' for a given line item based on the data pulled within the report. There are three seperate statuses; I then inserted a break which now seperates my three statuses into groups by that status, which is exactly what I want. I can't figure out out to get a 'heading' above the three groups though. Since I created a formula for the column of 'status', it won't let me drag that column heading to 'drop here to create a section' when I am in view structure mode . I would simply like to be able to have a static heading above each section and have scoured the options/formatting/etc. Is that possible to do?
Thanks
Why can't you create a dimension variable for Status and create section on that variable ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
New to business objects; valid question you ask. In my 'research', it is only a dimension value that allows for the section headers, which is why I havne't been able to figure this out. That said, I guess I am not clear on exactly what a dimension variable is or how to do that.
To drive my status, I created the following formula in that column:
=(If Not(IsNull([Income])) And (([Address]) <> "To Be Determined") Then "***Needs Action***" ElseIf((([Address]) = "To Be Determined")) Then "No Action - Property TBD" ElseIf(IsNull([Income])) Then "No Action - Incomplete")
Thanks for the reply.
No, Dimension didn't stick. I did, however, change the formula that I was using to drive the status. One of the objects in the formula was a measure; I used a different object that was a dimension in the formula and it then, in turn, allowed me to create the section header.
Thanks for the help.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.