OTBI report table view analysis - filter positive/negative values
Summary
OTBI report table view analysis - filter positive/negative valuesContent
Hello,
We need to customize the analysis table view of a custom report. We must create a filter so that we can pick whether we want the positive or negative or all values from the ledger amount field (costing subject area) in that view. Please find here attached screenshots of the views. We tried having a prompt but that can only show the positive or negative and it affects the grand total sum which is then off. We also tried adding "filters" new view but it says the analysis contains no filters.
We need to customize the analysis table view of a custom report. We must create a filter so that we can pick whether we want the positive or negative or all values from the ledger amount field (costing subject area) in that view. Please find here attached screenshots of the views. We tried having a prompt but that can only show the positive or negative and it affects the grand total sum which is then off. We also tried adding "filters" new view but it says the analysis contains no filters.
Tagged:
0