Hi Guys,
I have basically two Query, Appreciate if anyone can add
valuable suggestions.......

1 Redundent Data in Excel: I have got a Excel and trying to run a
pivot on it. Problem is: Like for ex. i have got a excel contains two
columns Refs: and Break, now for every refs there can be more than one
break, Please see below example, now i need to create a pivot which
shows the Count of Ref: and the all the break. Its bit tricky, any
suggestions will be highly appriciable.

Break Refs
break1 555
break2
break3 666
break4 777
break5
break6
break7
break8 888
break9 999
break10


2 ) I wan to get the filter of total in Pivot, if i wanna see the
total greater than 3 how can i get.

Count of Ref
Break Type Total
Break1 1
Break2 5
Break3 4
Break4 3


Many Thanks for your early response.



Regards,

Your data table is already setup the way a PivotTable would look, so I'm not
sure why you want to go that route.

What do mean by a count of refs? Perhaps you could just have a formula like:
=COUNTA(B2:B50)

Again, since your data already is condensed the way a PivotTable would show
it, I think we'll need you to explain more about what you are wanting to
accomplish.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


" wrote:

Hi Guys,
I have basically two Query, Appreciate if anyone can add
valuable suggestions.......

1 Redundent Data in Excel: I have got a Excel and trying to run a
pivot on it. Problem is: Like for ex. i have got a excel contains two
columns Refs: and Break, now for every refs there can be more than one
break, Please see below example, now i need to create a pivot which
shows the Count of Ref: and the all the break. Its bit tricky, any
suggestions will be highly appriciable.

Break Refs
break1 555
break2
break3 666
break4 777
break5
break6
break7
break8 888
break9 999
break10


2 ) I wan to get the filter of total in Pivot, if i wanna see the
total greater than 3 how can i get.

Count of Ref
Break Type Total
Break1 1
Break2 5
Break3 4
Break4 3


Many Thanks for your early response.



Regards,

On 8 Jan, 15:47, Luke M wrote:
Your data table is already setup the way a PivotTable would look, so I'm not
sure why you want to go that route.

What do mean by a count of refs? Perhaps you could just have a formula like:
=COUNTA(B2:B50)

Again, since your data already is condensed the way a PivotTable would show
it, I think we'll need you to explain more about what you are wanting to
accomplish.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*



" wrote:
Hi Guys,
* * * * * I have basically two Query, Appreciate if anyone can add
valuable suggestions.......

1 *Redundent Data in Excel: I have got a Excel and trying to run a
pivot on it. Problem is: Like for ex. i have got a excel contains two
columns Refs: and Break, now for every refs there can be more than one
break, Please see below example, now i need to create a pivot which
shows the Count of Ref: and the all the break. Its bit tricky, any
suggestions will be highly appriciable.

Break * * *Refs
break1 * * 555
break2
break3 * * 666
break4 * * 777
break5
break6
break7
break8 * * 888
break9 * * 999
break10

2 ) I wan to get the filter of total in Pivot, if i wanna see the
total greater than 3 how can i get.

Count of Ref
Break Type Total
Break1 * * * *1
Break2 * * * *5
Break3 * * * *4
Break4 * * * *3

Many Thanks for your early response.

Regards,- Hide quoted text -

- Show quoted text -

Hi Luke,
Thanks for the reply, Let me clearify that the example i have
given above is the sample of the data i have. I have large data in
excel sheet contains around 2000 Rows, Now I want to see them in the
pivot in such a way that i cover every Break Type and the reference
belongs to that. Count of Refs is something like while creating the
Pivot Table, we have the Count of Field which states the unqiue data,
but when i am taking refs and data i want to see the pivot in such a
way that vertical contains Type of Break (Break Type) and count of
shows the Refs. As there can be more than one break type for the refs
i want to see them in pivot.

Hope that clears the scenario, Please let me know if you need the
further information.

Also can anyone help me to figure out how can i deal with the scenario
2.

Appreciate your help guys.

Many Thanks,
Raj........