Help with chart

[hopkinsc]

Hi all,

I am trying to create a straight /pivot table showing figures for this year (broken down by group) but also including a TOTAL column for last year then showing the variance between them both.

I have included a sample, cam anyone help with this? i am not sure if it can be achieved. I know i can do it in seperate chartts but i need it to go on a report and look good.

I was hoping for a result similar to the below.

Many thanks

[bbi_mba_76]

Hi,

I think you could

1. concatenate the 3 expressions using the dimensionality() function to set the total value (ie if(dimensionality()=0, Expr1&' '&Expr2...)

2. use calculated fields

[hopkinsc]

Hi, thanks for your reply. is it possible you could show me what you mean using the sample please?

[Gysbert_Wassenaar]

You can fake it with three pivot tables and some text boxes.

[hopkinsc]

Hi Gysbert,

I have already tried that. it looks really good in the qvw itself but when i create a report and position the objects on the page it doesnt print everything correctly.

[Gysbert_Wassenaar]

Take 2.

[hopkinsc]

actually i dont think that will work either as it needs to be at date level not year, and all the dates are in the inline table which i think will be a lot of maintenance also.

there would need to be a record for every day of the year by reportingreasongroup by reporting group for a maximum of 2 years.

this seems to be harder than i thought