on 04-01-2009 3:46 PM
Hello BW Experts,
I wanted to know if there is a way to use a local formulas in Rows: i need to insert a row with a formula who adds/substracts other rows in a table.
I am using a hierarchy so i can not do that in the Query Designer.
Thanks in Advance,
Raffi
Hello BW Experts,
I wanted to know if there is a way to use a local formulas in Rows: i need to insert a row with a formula who adds/substracts other rows in a table.
I am using a hierarchy so i can not do that in the Query Designer.
->
Even if you are using Hierarchy you can subtract rows, for that you have to use structures,
Structures-> slection-> new selection>restrict your hierarchy nodes one in each element
Structure-> new formula-> subtract your Structure elements (rows)
For example if you have Region as your hirarchy and nodes are GA, TN, FL
you can create 3 new selections, restrict Regions to GA, TN, FL respectively
in the formula you can subtract GA- FL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.