Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In my DATAMART FINANCE, I need to visualize many fields into one field.
I have Dimension of Accounts:
- ID_COMPTE
-COMPTE : (for exemple : 712111)
- CODE CATEGORIE 1: ( 7 )
-CODE CATEGORIE 2: ( 71 )
-CODE CATEGORIE 3: ( 712 )
-CODE CATEGORIE 4 : ( 7121)
Id_compte | compte | CODE CATEGORIE 1 | CODE CATEGORIE 2 | CODE CATEGORIE 3 | CODE CATEGORIE 4 |
---|---|---|---|---|---|
1 | 712111 | 7 | 71 | 712 | 7121 |
2 | 712220 | 7 | 71 | 712 | 7122 |
3 | 714320 | 7 | 71 | 714 | 7143 |
I need to visualize the revenu by all the " CODE CATEGORIE " but in the same field, i'd like to have a report like this:
Revenu | |
---|---|
7 | 10000 |
71 | 1000 |
712 | 100 |
71211 | 10 |
712111 | 1 |
Can anybody tell me if its possible or not ?
Thank you.
Not really sure what you are trying to achieve. It somehow looks like your code category fields build a hierarchy and you want to show partial sums?
Then just create a pivot table chart with all account dimension fields as dimensions, as expression something like
=Sum( RevenuField)
Then go to presentation tab an enable partial sums for all your dimensions, or for the one you want to show partial sums.
Create a new table with a new field:
CategorieHierarchy:
CrossTable(Dummy, [CODE CATEGORIE],2)
LOAD
ID_COMPTE,
COMPTE,
[CODE CATEGORIE 1],
[CODE CATEGORIE 2],
[CODE CATEGORIE 3],
[CODE CATEGORIE 4]
FROM
[Dimension of Accounts]
;
DROP FIELD Dummy
The use the new field CODE CATEGORIE as chart dimension.
Thank you all for your answers.
swuehl what im trying to achieve is to have in the same fields in the report different hierarchy, whithout having all the details . for exemple id like to pick value 7 from code category 1 (which group many values of other code categories) and just the value 714 from code category 3;
Revenu | |
---|---|
7 | 1000 |
714 | 10 |
Do you mean create field that contains all the codes categories ??
yes