Ask Your Question
0

Comprehensive Pivot Table for Multiple Sheets in one File (Libre Calc) [closed]

asked 2013-10-19 02:39:54 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi, I have multiple excel sheets (Jan, Feb, Mar, etc) in one file (Total Year). I want to make a comprehensive pivot table for all the sheets. Is that possible with Libre Calc? Thank you.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 03:45:50.245819

Comments

OP:@AM640 .

manj_k gravatar imagemanj_k ( 2013-10-21 22:16:59 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2013-10-21 05:07:24 +0200

SolarDesalination gravatar image

sort of answer here: http://ask.libreoffice.org/en/question/2058/how-can-i-make-a-pivot-table-with-data-from-several-sheets/

In other words, I don't think it's possible, but I'm not a developer so I don't know for sure. I would recommend using Index-Match or Vlookup (if you're more comfortable with it) to create a worksheet with all the months together and then performing your pivot-table analysis with that sheet.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-10-19 02:39:54 +0200

Seen: 1,645 times

Last updated: Oct 21 '13