4 Replies Latest reply: Jun 8, 2011 6:43 AM by Erich Shiino RSS

    Calculated Dimension

    Byron Van Wyk

      Hi Guys,

       

      I have read through a few posts regarding this and havent come across a solution pertaining to my exact problem. What I am trying to do is build some financial reporting. In one of the SQL tables there is a column called AccountGroupDescription. This column has entries like Cost of Sales, Turnover, Current Liabilities et cetera.

       

      What I am trying to do is build a financial dashboard with 4 'fields' in the AccountGroupDescription. This needs to be a pivot table. So I have COS and Turnover, I want to add Gross Profit and Gross Margin % but they need to appear along with the above 2 in the dimension.

       

      I hope my explaination of what I am looking for makes sense and someone knows how I could possible achieve this

       

       

      Many thanks,

      Byron