I have a data set that collects information about the number services given on a day and the price charged for the services. The price charged for the service can change on a daily basis. I have created an Indicator that calculates the amounts of services given times the price of the service. It works nice on pivot tables when the period is daily, but if I change the period to monthly, the system calculates the indicator based on the last price given on that month. This makes a significant difference between the total when I sum the indicator on a daily basis from the monthly aggregate value. The service data element has an aggregation type SUM and the price data element has anaggregation type NONE, I have it this way because if it has an aggregation type SUM the monthly values multiplies the sum of services times the sum of all the priceces and the result goes way high.
I hope I explained myself with this issue, if anybody has any idea on how to make this indicator run on a monthly period I will appreciate it.