Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I need some help in formatting a dashboard. The details are as below
Filters
Year 2011 2012
Month Jan Feb Mar
Table
Year Month Type TitLe FTE Cost
2012 Jan Trade VP 10 40
Jan Sales VP 5 20
Jan Sales MD 10 42
Jan Trade OTH 5 20
Feb Trade VP 10 60
Feb Sales VP 5 20
Feb Sales MD 10 42
Feb Trade OTH 5 20
Ouput 1;
If Year = 2012 is selected the O/P should be
VP MD OTH Total Cost
Trades 10 5 15 140
Sales 5 10 15 124
Total 15 10 5 30 264
Cuurentl My output is
VP MD OTH Total Cost
Trades 20 10 30 140
Sales 10 20 30 124
Total 30 20 10 60 264
Outpout 2:
If Year = 2012 Month = Jan is selected the O/P should be
VP MD OTH Total Cost
Trades 10 5 15 60
Sales 5 10 15 62
Total 15 10 5 30 124
How do i avoid summation of values when selecting the year.
Thanks for the help
Can you post a sample?
Hello Phaneendra,
Sample qvw attached.
load this it will convert into Monthnames like Jan ,Feb................
Load * inline [
Month,MonthName
1,Jan
2,Feb
3,Mar
4,Apr
5,May
6,Jun
7,Jul
8,Aug
9,Sep
10,Oct
11,Nov
12,Dec
];
i thing it calculating correct as per your data
first try to calculate from data and match with dashboard.
see the attched file for reference