0

Filter on Global Dimension (Cost Account) with net change

Jet Reports Historic Posts

April 29, 2013 10:05

None

Follow

Hi,

I have a report with a replicator "Dimension Value" filtered on "Global Dimension No." = 1 (Cost Account) showing the net change per cost account on each G/L account within a range (one sheet per cost account).

I'm just trying to find a way to filter on cost accounts with a net change only within a given date filter and the given account range. I would prefer to filter that instead of hiding it afterwards.

Can somebody please push me in the right direction?


Cheers
André

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts April 29, 2013 14:47

  Hi André,
  
  Could you replicate your global dimensions out of the G/L Account table instead of out of the Dimension Value table? Then you could filter for Net Change, Date Filter, and account numbers. Maybe something like this:
  
  =NL("Sheets","G/L Account","Global Dimension 1 Code","Date Filter",[Your date range],"Net Change","<>0","No.",[Your G/L account numbers])
  Is something like this what you are looking for?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts April 30, 2013 11:00

  I tried it this morning but it doesn't work.
  I have done it with "hidesheet" now.
  
  I upload the report just in case somebody else has another idea.
  
  Cheers
  André

  • Vergleich Kostenstellen Jahre JR.xlsx