Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i have a question: my table does look like:
Phase 1 | Phase 2 | Phase 3 | |||
Projekt A | Bill | 100 | 25 | 60 | |
now: | Budget | 25 | 5 | 3 | |
Delta | 75 | 20 | 57 |
i want to create this view:
Phase 1 | Phase 2 | Phase 3 | |||||||
Projekt A | Bill | Budget | Delta | Bill | Budget | Delta | Bill | Budget | Delta |
100 | 25 | 75 | 25 | 5 | 20 | 60 | 3 | 57 |
i have tried to create this view by using of ValueList-Function, but i didnt achieve any results.
Does anybody have any idea?
Thanks a lot
Beck
How is your data being loaded if it is in the format
Project
Phase
Measure
Value
Then you should be able to present your data on the format you want via pivot
Hell Andy,
thanks a lot for your responce,
my data do look like:
Phase | Projet | Bill | Bugdet |
1 | Projekt A | 100 | 25 |
2 | Projekt A | 25 | 5 |
Slightly modify it so the bill and budget are facts about the project phase so
Project phase measure value
A, 1, bill, 100
A, 1, budget, 25
A, 2, bill, 25
A, 2, budget, 5
What do you mean with slightly modify? How can i achieve this structure? with help of Crosstable?
try like this:
Tab:
Load * Inline [
Phase,Projet,Bill,Bugdet
1,Projekt A,100,25
2,Projekt A,25,5
];
CrossTable(PhaseName,Value,2)
Load
Phase,
Projet,
Bill,Bugdet
Resident Tab;
Drop Table Tab;
Load the data as it is
Tab:
LOAD
Phase,
Projet,
Bill,
Bugdet,
Delta
FROM [lib://Data/Book3.xlsx]
(ooxml, embedded labels, table is Sheet3);
Now Add Dimension : Project & Phase
Now Add Expression :
Bill : Sum(Bill)
Budget : Sum(Budget)
Delta: Sum(Delta)
Now it will show like this
Now Press Done and Drag Phase before Measure
Apply the changes and it's done
Thanks a lot for your responce Nallani
Hi Basak, thanks a lot for your responce and time