Using Layout calculation in chart

[mel4363]

Hi everyone,

I have a report reporting of a SQL database, I wanted to calculate average based on the number of items selected in the prompt page (Months). I was able to achieve this by using a layout calculation on the crosstab using ParamCount(Month) function.

My challange now however is that I have to use the same item on a pie chart but I get an error when attempting to insert a Layout calculation in the default measure. Is the a way around this? or a different solution ?

Thank you in advance

Mel

[MFGF]

Hi everyone,

I have a report reporting of a SQL database, I wanted to calculate average based on the number of items selected in the prompt page (Months). I was able to achieve this by using a layout calculation on the crosstab using ParamCount(Month) function.

My challange now however is that I have to use the same item on a pie chart but I get an error when attempting to insert a Layout calculation in the default measure. Is the a way around this? or a different solution ?

Thank you in advance

Mel

Hi,

Layout calculations are (as the name suggests) intended to be used in the report layout areas (ie places like the page header or page footer). If you want to define a calculation in a reporting object which is associated with a query (eg list/crosstab/chart etc) you need to use a Query calculation.

If you want to know how many items were selected in the prompt, all you need to do is to count the number of months displayed in your reporting object in a query calculation

eg count([your month item] for report)

You should have no issues bringing a query calculation into your pie chart.

Cheers!

MF.

[mel4363]

Thanks a lot MF. It worked.

I had not included the report at the end of my calculation

Thanks again

Mel