I have a filed called as 'value' and 'Percent'.i have to design the report in design level as follows.
value percent
10 15% (i.e total/value)
20 same formula
30 same formula
40 same formula
50 same formula
Total 150 Toatl : Here
I need first this req.
second is below.
Note : value field is coming from datasource.we have to calculate percent and we have to create the YTD,MTD script as well.
i.e. if we select the partcicular year,month then the data in the value and percent should not change.
Need data as follows :
A. up to current date (if am selecting anything in the global filters is has to show current date data only.It means it won't change the data in table as per selections.)
ID(Dim) value percent
5 10 15% (i.e total/value)
10 20 Same formula
30 30 Same
40 40 Same
50 50 Same
Total 150 Total : here
A. up to previous month (if am selecting anything in the global filters is has to show current date data only.It means it won't change the data in table as per selections.)
ID(Dim) value percent
5 10 15% (i.e total/value)
10 20 Same formula
30 30 Same
40 40 Same
50 50 Same
Total 150 Total : here
C.Based on selections :it has to show the data as per the selections.
ID(Dim) value percent
5 10 15% (i.e total/value)
10 20 same formula
30 30 same
40 40 same
50 50 same
Total 150 Total : here
NOTE : So the total 6 expression are in same chart and features have to change as per your above req.
