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
Have you tried creating a "Aggregate(CurrentMeasure within [Column]) " calculated field and just stacking as rows in crosstab?
I just tried. But did not worked out. >:(
Quote from: pooja on 22 Apr 2014 02:19:59 PM
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.
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.
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
Quote from: pooja on 24 Apr 2014 10:23:26 AM
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.