Is it possible to display current, previous and % in one single row in straight table?

[#1]

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

[ToniKautto]

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.

[Peter_Cammaert]

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