Referencing aggregated data in cross tab

Hello,
Could you please advice on how to reference a agregated datafield in detail area of a crosstab? I need to use this value in a skript in event onCreate and have a problem to get it. Depending on the value I do some formatting in a different column of the same crosstab..

I was able to get value in dimensions:
Value = dimension["Typ"]["AP_H"]
but this does not work for detail area and agregations.

I tried also
value = SUM(measure("AS_HODNOTA"));
but with no success.

as well as
Please, help whith how I shell write the skript...
Thank you in advance

Find more posts tagged with

Comments

mwilliams

You're trying to grab the value of a measure in the onCreate script of your crosstab? Or are you creating an aggregation in a derived measure column and trying to access its value? Let me know. If you can create a report with the sample database that shows what you're tying to do, that might help as well.