To Calculate difference instead of total in crostab

[saumil287]

Hi All,
I am having a crosstab containing Main-category,Category,sub-category in rows and fy2010-11 and fy2009-10 which contains revenue as columns.
I want to calculate difference only for Category named Fixed Assets in Place for Total(Sub-Category)
I used the running-difference func but displaying an error.
RSV-VAL-0034 Failed to validate the variable String1
I also used the string var to calculate the diff for Fixed Assets

Need your guidance.
thanks in advance

[blom0344]

Difference between what? Please give us an example..

[saumil287]

Hi Blom
Below is an eg
Main-Category   Category    sub-Category    FY10-11
  A                           a1                    w             20
                                                        s             30
    Total(Cat)                                                    50
  B                            b2                     g             20
                                                          f             10
                             Net (Cat ie Fixed Assets)    10

I am having Main-category,category  and sub-category and FY10-11(revenue column)
In crosstab or List I am able to achieve the aggregate or total as shown for main-cat A
in the entire list or xtab
What I want is only B catgory to be calculated as diff as shown (g and f) and rest all catg to be cal as total or aggrgate.
This is balance sheet I am creating.
I am able to do diff but it is giving me for entire rep.
I only want diff to be displayed only for say Category B.

Your guidence is appreciated
Thanks again

[blom0344]

But then what if main cat B has sub-category f,g and h  ?

[saumil287]

Hi Blom,
I am having only F and G currently.
What I tried is using running-difference func to achieve the same.
Also using Conditional Block My data is coming incorrect and entire column goes for running-count.

If sub-cat is having f,g,h then I may use the running-difference func.
Because there is no difference calculation from the aggregate property.
Need your guidance