9 Replies Latest reply: Oct 14, 2013 7:36 AM by Anju Gopinath

Problem of calculation

I have multiple tables in my database in qvd file my data corresponding to actual and budget is in the form of:

Table A                                         Table B                                      Table C

Col1    pk_Col2                                pk_ Col2  Col4   pk_Col7         Col6             pk_Col7

Actual     1                                        1          500         A5           Total Assets     A1

Budget     2                                       2          600         A6           Total Revenue     A2

LEjan       3                                       3          700         A7          Current Assets     A3

Lefeb        4                                       4          800         A8          Sales Direct          A4

have to make a chart like:

Balancesheet

Actual     Budget     Prior Year          Prior year%

total revenue          calculation     cal.     cal.                    cal.

Current Liabilities     cal.               cal.          cal.               cal.

total  Asset          cal.               cal.          cal.               cal.

where these calculation is based on the col4 data corresponding to the dimensions as in chart. And i made the neccessary relation between tables by making the field name common.

• Re: Problem of calculation

Hi Poornima,

In a Pivot table,

you can add two dimensions in this order:

Col6,col1,

Then you can make col1 horizontal.

But, what is prior year and prior year %?

-Anju

• Re: Problem of calculation

these all are calculation fields these data are not given in the col where actual and budget is given,

I have attached the database regarding these fields

• Re: Problem of calculation

Ok.

How is prior year calculated?

• Re: Problem of calculation

Hi,

Can you explain, How to calculate the Prior Year fields?

• Re: Problem of calculation

Take Col1 and Col6 in dimension.

When the chart appears,just click on the col1 header and drag it above the calculation part.

• Re: Problem of calculation

My table B is as

My tableA where prior year  and prior year % can be checked by quarterly, halfyearly and yearly

This is my table C which is forming an hierarchy for calculation:

• Re: Problem of calculation

ok.. so we have table c for calculating prior year.

How do we calculate it?is it count of pk_dim_pov ..or something like that?

• Re: Problem of calculation

Hii Anju,

I want to make a chart in which All the values come from table A stri_pov_code but not parent,actual and budget as dimensions and values of money_measure from table B for some measurement present in tableC str_coa_description.

How Can I make it?

• Re: Problem of calculation

Hi,

In a pivot table,