PDA

View Full Version : [SOLVED] Consolidate a table with keeping 3 column criteria



nhiribarne
03-19-2015, 11:14 AM
Hello everybody,
Please, find attached the file I'm working on.

13038

My goal is to get from the sheet "Datas" to the sheet "Resultat". I tried to do a Pivot Table but the closest Pivot Table I could have get give me 3 line for each item I need.
I was wondering if it's possible to use an excel fonction to just have the lines with the date on the Pivot Table or if it's possible to use some excel function to automatically create the table I have in sheet "Resultat" from the sheet "Datas".

Thank you very much if you can help me !

If something is not clear in my description, please, ask me :-)

nhiribarne
03-23-2015, 02:10 AM
Nobody able to help me ?

jonh
03-23-2015, 03:08 AM
Select the Pivot sheet
Go to the Design menu
Select 'show in tabular form' from Report Layout
Select 'don't show subtotals' from Subtotals

nhiribarne
03-23-2015, 04:15 AM
Ok, that's alreqdy way better that I was doing.
But, do you know if there is any possibility for me to have the Asset description and the Asset class in line 7, 9, 10 and 12 after I do what you told me?

Or the somplest way is to paste as value and create a IF formula saying if the cell is empty, then take the value of the cell right above the actual cell?

Thanks

nhiribarne
03-23-2015, 04:20 AM
Ok, found it.
Just have to had "repeat label" in the field setting.
Thank you very much John. I tried mulptiple thing in the Design but could not reach this point without your help.

Have a good day.

Subject solved