Counting objects in a pivot table

[stekol61]

Hi!

In the encosed document I want to count number of Node Id's for each Object and Tech and for the last week available.

I've tried to use this expresion but If I select several weeks the result will be aggregated

*=Count ({<Tech= {'3'} >}[Node Id])*

How can this be done?

[stekol61]

OK.

Here it is

[sunny_talwar]

Where is Tech in this qvw?

[stekol61]

It's incuded in the expressions. e.g. "4 Availability" is showing data for G4

[stekol61]

e.g "MCDR (4)" looks like this:

=num(100-((sum({<Tech= {'G4'} >} [Call Fails])+sum({<Tech= {'G4'} >}[Call Drops]))/sum({<Tech= {'G4'} >}[Call Attempts]))*100,'# ##0,00')