3 Replies Latest reply on Apr 27, 2018 7:56 AM by Robert Angel

    Working with Direct Database Reports - calculated measures


      Has anyone found a way to be able to create calculated measure in pivot tables using direct database queries? I'm trying to divide to show the % change between two columns and then summarize it with a grand total. No aggregation rule works for this (it just sums the percent changes in each row) so a calculated measure would be best. Problem is, since a Direct DB report does not come from a subject area it appears to not allow me to create one.