Update/Modify Crosstab fact cell

[pooja]

Hi All,

It is possible to update/modify particular crosstab fact cell? I have an strange issue-
In report we have Month, Quarter & YTD columns against multiple accounts rows as measures. Which includes VAR% and GROSS% as percentage rows too. When I applied total formula for Month, Quarter & YTD column - numbers are coming good. BUT- problem with VAR% and GROSS% which should have average on Quarter & YTD column instead of total. How can I achieve both total & average on same column???

Accounts                        Month                   Quarter               YTD
--------------------------------------------------------------------------------
revenue(total)         
expenses(total)
VAR%(average)
Gross MArgin%(average)


Thanks,
P

[LFC]

Have you tried creating a "Aggregate(CurrentMeasure within [Column]) " calculated field and just stacking as rows in crosstab?

[pooja]

I just tried. But did not worked out. >:(

[MFGF]

I just tried. But did not worked out. >:(

Pooja, I refer you to this post, paragraph 1 part d, to be precise:

http://www.cognoise.com/index.php/topic,24030.0.html

MF.

[pooja]

Sure MFGF,

I apologize.

When I tried as per LFC - Aggregate(CurrentMeasure within [Column]). it works for only VAR% and GROSS MARGIN%, but other numbers too came out as aggregate, which should be total. 

[pooja]

Hi all,

I resolved this issue. I built the report using multiple cross tab. Using one crosstab for each VAR% & GROSS MARGIN % rows and inserted between other crosstab.


P

[MFGF]

Hi all,

I resolved this issue. I built the report using multiple cross tab. Using one crosstab for each VAR% & GROSS MARGIN % rows and inserted between other crosstab.


P

Thanks for the update and for posting the solution. We appreciate it!! :)

MF.