Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I'm having trouble displaying my report.

Hello,

My Receivables on Year 2009 is 1,098,301,231.64 and my Receivable per quarter is 274,575307.91, every time i make a chart it always display my Quarterly Receivable.

Can you help me to display the 1,098,301,231.64 Receivable on the chart?

Please Help me on my project.

Year Receivable.png

Quarter Receivable.png

Untitled2.png

Here is my some photo attached

2 Replies
swuehl
MVP
MVP

Well, that's hard to answer with the information provided (i.e. lacking information about the data model, chart dimensions, expressions etc.).

Please double check that you don't have any selections in field Quarter when  you are creating a chart with dimension Year, since the selections will affect the data aggregated in every chart (this is QV default behaviour).

You can clear selections in expression evaluation using set analysis, maybe this is the case in other charts you are looking at.

Anyway, without knowing more details about your settings, I think it's just wild guessing.

Not applicable
Author

sir I just forgot to add the Aggr() function. I already get the correct answer.
btw Thanks for sharing your idea