Suppress column value in facts table

Question

Note that my version ( 11.1.1.7) is no longer current.

An analysis produces a report of about 25 columns detailing payment transactions to each vendor for a billing period.

The requirement is to suppress the "care days" column so that it only appears once for all of the payment transactions for each vendor for the billing period.

By populating that column only once, the aggregate value would avoid inflating the value of that data element.

Online search indicates that the suppression option will not work for a facts table.

I do not know whether a union of two reports would work in this situation since the  output from the analysis consists of 25 columns.

Any suggestions are appreciated.

3713479 · Answer

The solution is to reorder the columns so that the column to be suppressed is among the leftmost columns in the output.

This was mentioned in another submission on this forum.

3713479 · Answer

Each vendor will have multiple payment transactions for a given billing period that are visible in the report, but I only want to display the column in question( care days ) once for one of the transactions for that vendor/billing period.

The other transactions for that vendor should show a null value for that column.

Note that the user has the option of populating a dashboard prompt for this column.

I am not clear on the suggestion of moving the column to a section.

Joel Acha · Answer

by suppressing, do you mean remove the column from the analysis?

Have you tried moving the field over to sections or table prompts?