on 07-08-2010 10:46 AM
Hi all!
I have a crosstable with a group made up of a field that contains dates.
The report can have 3 - 4 - 5 columns depending on the selected customer.
I want a calculated member for each date that I give a percentage between two fields that I have identified.
My problem is that if I add a calculated member it makes me just for the column from where I started.
But I want a dynamic column for each client regardless of the date I selected.
is it possible?
I tried using the expert calculated member but as the column of type date I will not allow me to perform calculations on fields that I am.
Thanks
Stefano
Don't think you can do this in a Crystal genertaed Crosstab.
You will need to build a manual Cross tab
this is where you create formula to define your columns and then add sumaries to a group footer.
Typically a column formula will look like
Col1
If (column1 condition) = true then valuefield else 0
Col2
If (column2 condition) = true then valuefield else 0
This does mean that you have to know the maximum number of columns prior to report design.
You can then perform condtional %age diff on the summaries depending on which contain data.
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
....................date1 | mycalculatedmember | date2 | xxxxx
-
row1........... value1 | value1/value1*100 | value2| ....
row2........... value2 | value2/value1*100 | value2| ....
The calculation made for date1 also for date2 automatically without first knowing the number of columns
This is my problem.
any suggestion about it?
Apologize to you and probably you're right, do a little hard to explain.
I have a number of columns that date can vary by client.
for example I have a client who purchased during 2009 and 2010, or customers who have made purchases in both 2008 and 2009 and 2010.
For these cases I want a column to the right of each date column I calculate a 20% increase for each item of all the columns in my reports.
You understand that if I create a dynamic report so if I have 3 years I have 3 columns and 3 calculations, or if I have only 2 should have only 2 columns.
What I can not do is manage this dynamism.
Have been more clear in my explanation?
I think you have to eliminate the dynamism and fix your columns, you can only do this with a manual cross tab,
Each column would be fixed
Typically a column formula will look like
2008
If if year(datefield) = 2008 then valuefield else 0
2009
If if year(datefield) = 2009 then valuefield else 0
You can then perform condtional %age diff on the summaries depending on which contain data.
YOu can have some dynamism by using formula to run for say the last 3 years, so that when you go into 2011 columns automatically switch to 2009, 2010 & 2011.
eg create formula to replace years above, so instead of 2008, use
@year1
year(currentdate)-2
Same formula can be use as you column heading too.
Ian
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.