Adding Row in cross tab and planned numbers

[Former Member]

Hello one and all!

I was hoping that someone might be able to help me.

In a crosstab is it possible to add a row below and then add numbers going across this row to the cells?

I have referral actual numbers for the month going across the top and below this I would like to add the planned number of referrals that have been pre-calculated and will not change.

Basically I’m having to add forward plan numbers for the next financial year so each month I have the actual number of referrals and then below or above this I need to have a row and have the planned number of referrals for each of the months. Again below this I will have a variance and a variance %.

Is this possible to do at all?

If this doesn’t make any sense please let me know and I will try and explain it a little better!

Many Thanks in advance!

Nick

[Former Member]

This is possible but you're far better adding the data to the database in a budget table.

Create a table with Speciality, YearMonth and Budget columns, get them populated then include the table in your universe.