Pivot talbe and calculed elements

[cyrilz]

Hello all,


I have the following table and I want to summarize it in a Pivot Table, adding some calculated elements.

[pre]

Item       Function   Status
Item1      Func1      OK
Item1      Func2      NOK
Item2      Func3      {empty}

I have created a Pivot Table like this

[pre][code]# Status
OK    NOK    empty
Item / Function<
Item1
Func1             1
Func2                   1
Item2<br />
Func3                          1

[/pre]
When I add a calculated elements, which formula is IFERROR(STATUS.OK / STATUS.NOK; 0)

The Pivot table becomes :


# Status
OK NOK empty calculus1
Item / Function
Item1
Func1 1 100%
Func2 1 0%
Func3 0%
Item2
Func1 100%
Func2 0%
Func3 1 0%[/code][/pre]
Func3 is added to Item1 and Func1+Func2 are added to Item2.


How can I avoid this, and keep the grouping I initially had ???


regards

 

[cyrilz]

hello again,


it seems to me nobody as an idea


Like Chandoo, I'm (re-)learning Access (in fact actualizing my knowledge)


Cyril