My fiscal year starts from April. How can I group with fiscal year like this?
Select items,sum(sales), date from tableA
2007
2006
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
1
Books
10
20
0
0
0
0
0
0
0
20
50
0
25
10
10
0
0
5
0
25
15
10
10
20
2
Panel
10
10
10
20
20
10
10
20
10
10
10
10
20
20
20
20
30
30
10
10
10
30
30
30
3
Frame
Try to add your fiscal year at your Time dimension.
Helped?
Regards
|||Is it possible user date field group to like this in matrix?
2005-4-1 to 2006-3-31
2006-4-1 to 2007-3-31
4
4
1
Books
10
25
2
Panel
10
20
3
Frame
6
6
Dear Friend,
the both columns is based in the date parameter of your report, correct?
You only need 2 periods? 1 year ago and 2 years ago from parameter date, correct?!
Regards!
|||Hi PedroCGD
The columns is based in the date parameter. I wants to do 5 year periods. Can you help me?
|||Yes I'll help you, but only in a few hours when I arrive home!!
You'll get it! Dont panic! :-)
regards!
|||palm99,
Can I try resolve your problem or you already resolved?
Regards
|||Hi PedroCGD
I am waiting your help.
