6 Replies Latest reply: Dec 31, 2012 6:31 PM by khadar basha RSS

    How to show total number or records?

      Hi,

       

      I have attached a sample qvw in which I want to show total number of records of a chat table in a tex box.

       

      There are two chart tables in the sample file, one is with IF and one with SET.

       

      Total number of records need to be shown for both types of tables seperately, as you can see two seperate taxt boxes.

       

      Can some one help me out writing expression?

       

      Currently I am using following

           =Sum(Aggr( <your table expression> , <table dimension 1>, <table dimension 2>, ...))

       

      But it not showing the correct number of records.

       

      Your input will be highly appreciated.

       

      Thanks,

       

      TA