Hi dudes, I'm using dimensional package to create a report. Here I use cross table column in hierarchy format like work as top and budget/actual as measure
| work
|----------------
person|budget | actual
| |
==== |==========
This is my cross table design. Work as number of sub group. Q1) I want to customize that group and show only that specific group to display. It was achieved in relational package but having problem in dimensional package!
Then
Q2)How to calculate sum of actual value only for selected work group that stored in another column.
Q3) When I performed Auto summary for person wise actual value only got exact result budget as 1. How to solve this problem.
Q4) how to get the report in column wise? Relational package data are presented in column wise what i'm design in table but dimensional wise report each person data display individual work group that mean person 1 data displayed person 2 data display under the person 1 but here I got another set of work group then displayed (i.e) I want to scroll left to right to get all data.
Thank you in advance.
Report studio only display multiple column of designed column for each row of dimensional package?