Happy to report that some of the functionalities are already in the product (all the basics for creating Pivots!) and some in preview (i.e. advanced filtering, calculated fields) .
please see the details here.
You have to give this functinality as soon as possible it is very fantastic .... waiting for this feature.
Having the ability to create custom pivots programmatically would be useful feature for reporting latest data for better user experience.