I have the following fields i want to analyse the trend over months with 2 calcuated fields
% of premium of outstanding premium and % of Premium booked.
Now my question is
1.Should i change the calculated fields to discrete?
2.In analysing the trends i don't want to sum my calculated field.
Please find the twbx attached.
To analyze the trends for last 6 months, you can use a calculated field IF DATEDIFF('month',[work_date],TODAY())<=5 THEN [work_date] END . This would be display you the trend for last 6 months.