• From: USA
  • Registered: 03/26/2013
  • Posts: 93

Topic: Reports and Analysis

Under - Reports and Analysis -> General Ledger -> Profit and Loss Statement, you can get reports for specific dimensions which is very helpful, but what about if you want to exclude a dimension from the report.

  Profit and Loss Statement for all sales except a dimension or two.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,163

Re: Reports and Analysis

Take full P&L (rep707.php) as one report.
Take only Dimension 2 in another report.
Now use the difference wink

Alternatively, make a temporary modification to the SQL in the report file and invert the logic to get all but dimension 2. $_POST['PARAM_3'] > 0 && isset($_POST['PARAM_9']) && !(isset($_POST['PARAM_10']) will be for the presence of a single dimension.

apmuthu's Website