CODEWITHSUNDEEP
birtcrosstabdata-cube
user6328945
user6328945

Reputation:

BIRT: How to find average of derived measure in cross tab in spago BI?

I my BIRT Report i am using a data cube to show some data with the help of cross tab.In the cross tab i added a derived measure with the help of other measures.

Question: How to calculate the average of that derived measure in the cross tab?

Please give the answer of my question. Thanks

Upvotes: 0

Views: 472

Answers (1)

user6328945
user6328945

Reputation:

In my case i made a derived measures depending on the other measures.

Suppose i have 2 measures names are monthlyRent and totalRent. With the help of these two measure i made a derived measure like this:

derived measure = (monthlyRent/totalRent)*100

Now i want to calculate the grand total for this derived measure.

Steps:

  1. Right click on cell.
  2. then insert.
  3. Dynamic Text.
  4. Available Column Bindings.
  5. cross tab.
  6. then selected the both measures monthlyRent and totalRent.

It will be like this: (data["monthlyRent"]/data["totalRent"])*100

Regarding any help you can contact me i will provide the practical example for this.

Thanks

Upvotes: 0

Related Questions