Report Based on Dimension Set ID using the Analysis by Dimension with Jet G/L function

Hi All,

I have prepared a basic jet report using the g/l function and using analysis by dimension. Ideally, I would like the report to return the values from the 'Data Revenue sheet when analysis by dimension is downloaded. However, the jet report is only looking at the balance and not the transaction.

I prepared the same report using the g/l entry table but is taking too much time to run.

Could you please advise what I need to do?

Thanks.

Dz