none
How would I count items in DataSet2 and have them grouped by the column that is tied to DataSet1? RRS feed

  • Question

  • Greetings!
    First, thank you for looking at my question. I am trying to count the number of items that = "True" in DataSet2 and display them in the "Week" column in a table who is pointed to DataSet1.
    I have a simple table that is set up something like this:

    CDC Week | [Week Number] from DataSet1 | Total
    Count of Some Item | [CountSomeField] from DataSet1 | [ Total of Row]
    Count of Another Item |  [CountOfTrueItems] from DataSet2 | [Total of Row]



    With the expected results:

    CDC Week | 25 | 26 | 27 | (n/a)
    Count of Some Item | 10 | 20 | 30 | (Expected 60 but not working yet)
    Count of Another Item | 5 | 10 | 15 | (Expected 30 but not working yet)



    Instead I get:

    CDC Week | 25 | 26 | 27 |  (n/a)
    Count of Some Item | 10 | 20 | 30 | (Not working yet)
    Count of Another Item | 30 | 30 | 30 | (Not working yet)


    DataSet1 has a few columns including a "Week" column. DataSet2 has two columns, "WEEK" and "POS".

    I need to count items when POS = "TRUE" in DataSet2 and group them on the "Week" column.

    My current expression is =SUM(IIF(Fields!Pos_.Value = "True", 1, 0), "DataSet2")

    And while this returns a value, it does not count (or sum) by each week. I am missing something...

    Thank you for any assistance!

    p.s. Sorry My html skills are not shining with the table formatting :(

    Friday, March 13, 2015 3:36 PM

All replies