6 Replies Latest reply on May 11, 2017 9:12 PM by Shinichiro Murakami

    Calculation in a Pivoted Workbook

    Chris Warton

      I have a simple spreadsheet showing, for each user on each day, their number of logons, logoffs, their entitlement and their usage. I want to show each of those categories for each day as columns, with users on the Y-axis.

       

      Great, I can do that by pivoting the table, as I've done in the attached workbook.

       

      My problem is that I want to show a calculated figure. For each user for each day, I want to show as another column usage/entitlement (as a percentage). That calculation was easy enough to do before I pivoted the data, but once I do, I lose the usage and entitlement values, so I can't create the calculation, much less show the result in the vis.

       

      What am I missing?