Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi, Everybody, I have a dynamic table that looks like this:
A B C 1 Contry State Sales 2 Brasil SP 50.000 3 RJ 40.000 4 MG 30.000 5 Peru Lima 20.000 6 Cusco 10.000 7 Machu Pichu 5.000 The thing is I would like to have it with the field 'Contry' duplicated in every line or simply like this: A B C 1 Contry State Sales 2 Brasil SP 50.000 3 Brasil RJ 40.000 4 Brasil MG 30.000 5 Peru Lima 20.000 6 Peru Cusco 10.000 7 Peru Machu Pichu 5.000 It may sound as a dummy question, but I´ve overlooked the dynamic table properties at all and couldn´t find no answer. I would appreciate a lot if any help will offered. Best regards, Flávio São Paulo, SP Brazil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Dynamic Field | Excel Discussion (Misc queries) | |||
Pivot Table Layout Help | Excel Discussion (Misc queries) | |||
Dynamic Table | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
keep pivot table layout | Excel Worksheet Functions |