Is it possible in pivot or straight table

[arulsettu]

hi,

i need to do a calculation in row wise

for example data is like this.     Account and Amount are fields available

ACCOUNT                                                  AMOUNT

Gross premiums                                            100

RI Share of premium-FAC & Prop. TTY            200

XOL Protection costs                                      300

Movement in unexpired premium                      250

what i need is

ACCOUNT                                                  AMOUNT

Gross premiums                                            100

RI Share of premium-FAC & Prop. TTY            200

XOL Protection costs                                      300

Net premium                                                sum of above 3 rows

Movement in unexpired premium                      250

Net earned premium                                    Net premium + Movement in unexpired premium

like this i have to do few more calculations within rows. is this possible to do? or any other alternate ways to do?

please suggest some ideas

Thanks

[arulsettu]

Hi Sana,

          i am having Acount_code and Acount_company_code as key. can i give this in interval match

       key   Account:

      001      report header                                              report_start      report_end                   

      002         Gross premiums                                            1                        1

      003        RI Share of premium-FAC & Prop. TTY             2                        2

      004         XOL Protection costs                                     3                        3

       005        Net Premium                                                 1                        3 

from account  

IntervalMatch:
INTERVALMATCH (key) LOAD 
report_start,
report_end
RESIDENT account;

like this?

plz help

thanks

[arulsettu]

this is example for subtract

to find

Profit for the period = Profit for the period before BOD remuneration & expenses-BOD Remuneration & expenses

the amount in positive

thanks

[#4]

Arul, your way is to komplex. You have to calculate the sum not in the Pivot-Table, when you want a Intervall. You must set the Intervall with the Dimensions. The Dimensions could you get in the Generator. And there you must on example the

Intervall_1:

Load

field_a, month. day, year;

SQL select

month(datefield) as month, day(datefield) as day, year(datefield) as year, field_a from table_1;

Then you could work with the fields day,... or you to choose in the Listfields in Connection with the Pivot-table. When you Change only  the 2 May and 4 May an the 5 May 2015, then you could make the sum in the Pivot-table. All other ways is very strange.

[arulsettu]

shall i give my sample file so i can understand easily

[#6]

Yes.

[nagarjuna_kotha]

send it ASAP

[#8]

You a Dimension. And I see

Weekdays, Months, MonthDays, MonthInternal, DailyCounter, HourlyMinutesCounter, MonthlyDays anything as condition in the qvd, also from the Generator.

Where is now the Problem, 2 or 3 Listbox with. On Listbox with the Dimension "MonthDays", a other Listbox with the Dimension "Months", a other with the weekdays.

Now you have the Pivot-Table. And the Dimensions of the choose in the Listbox are to connect with the Pivot-Table. When you choose the May in Listbox, then it is also for the Pivot-Table. And here you could make the sum.

[arulsettu]

HI Sana

                    can you please check my app

[arulsettu]

Sana can you send the sample file of yours. i am bit confused about creating ids and mapping. plz send a example or check my sample.

Thanks

[#11]

Hi could you send me your email address pls. Thnx