Cross Tab Calculated Member

[beth4530]

I have added a column to my cross tab as a calculated member"% Seen". The calcuation formula is
formula= sum(formula),group/distinctcount(field),group
It's only pulling in the very first % for all the months. How do I get it to calculate for each month?

 

[CoSpringsGuy]

explain more about the rows and columns of your cross tab... Calculated members work great but they are hard to visualize. If you could attach a picture of how it looks now that would be a big help as well.
If you cant do that, when editing your formula, look under functions and you will see a category called grid values. Thats where all the secrets of calculated members and embedded summaries are. They take some getting used to but are very useful!

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[beth4530]

There are 2 columns, FY12 and FY13 and the rows are months-- Is it possible to have the summary row only calculate for the MTD of the current FY?

 

[CoSpringsGuy]

click this link

https://join.me/163-908-861

follow instructions



_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection