1 Reply Latest reply: Feb 11, 2012 1:34 PM by Ashutosh Paliwal RSS

    Error in calculated dimension

      Dear All,

       

      I am trying to generate a report using chart -> straight table and would like to fitler the data. I have a straight table with all the columns as dimension and expression =1. the straight table gets generated properly but when i am trying to filter the data i am getting error in calculating the dimension".

       

      I have the following data

      QtyPriceBuyerSeller
      20002.0ABCXYZ
      30002.2ABCPQR
      30002.0XYZPQR
      40002.0ABCAAA

       

      I have a list box containing all the buyer and seller and would like to filter the above data based on the selection in the list box.

       

      i have the dimension for buyer as

      only ({<buyer = {"$(=getfieldselections(Firm))"}> buyer) ... where Firm is the list box used for selection.

       

      Kindly let me know how i can get this data filter...

       

      Thanks and Regards,

      Qaiyum

        • Error in calculated dimension
          Ashutosh Paliwal

          Hi,

          Sorry, for my previous post, I could not get your point correctly.

          You have to use advanced aggregation, you can not use group functions directly in calculated dimensions.

          Try this expression, it will work.

           

          =aggr(only({<Buyer={"$(=GetFieldSelections(Firm))"}>} Buyer),Buyer)

           

          Let me know, if any issue.

          ..

          Ashutosh