Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have inline data contains date, Amount . I want to display straight table with month as dimension,
Current month amount, previous month amount and %(( current amount-previous amount)/previous amount) as expressions. If I selected one month it display corresponding month value, previous month value and %.
I am design the straight table but not display corresponding values.
Please find the attachment.
Please any one help me . its urgent
It is impossible to make a proper suggestion based on your screenshot. In order for anyone to provide detailed advise, a sample QVW file is required. The file will make it possible to see what the data model looks like, what your chart setup is and validate any possible solution.
Please attach a sample QVW and explain what the expected results are int he chart you have highlighted, meaning what number do you expect to see if the chart returns the correct values.
Quick answer for rapid implementation by a community member in a hurry:
Search the community for a concept called an "ASOF-table". That'll help you.
Good luck,
Peter