close

In a pivot table report I would like to add a calculated field that is like
the following:

= count( columnA ) / count ( columnB)

But when I create a calculated field like the above, all I get is a value of
1 in every row of the pivot table.

I realize after some experiments, its really performing

= count( sum ( columnA ) ) / count( sum ( columnB ) )

So , how do I get what I want?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄