[Solved] Can't get Data Pilot working

[Fluffyb]

I've googled, I've read help files and previous posts, I've reset user-data and toolbar and I am at the end of my knowledge . How do I get DataPilot working? Help? (Posted here due to being beginner and not knowing where to put it).

All help appreciated.

[Fluffyb]

I am trying to get a hang of this DataPilot/Pivot and I can't seem to get the data to attatch to the new columns. I've tried a couple of different tables and data types, dates, text with numbers and the same keeps happening.

What am I doing wrong here? Any suggestions?

SOLVED -
Sales were supposed to go in DATA.... sorry.

[robleyd]

G'day and welcome to the forum.

Unfortunately the image you have posted doesn't help to find a solution for your problem. Can you upload a sample spreadsheet with data that you want to use in a Pivot Table - formerly known as Data Pilot.

You may also find https://wiki.openoffice.org/wiki/Docume ... /DataPilot a useful resource.

Edit: Please don't post multiple questions on the same topic. Please read the Survival Guide which suggests "No multi- or cross-posting. It leads to several discussions and a waste of time because several identical answers may be posted by different users." I've merged both your topics into this one.

[Villeroy]

Screenshots don't help to understand the problem but from what I can see in the first one, your source table is a contingency table (aka cross table, pivot table) with 7 day categories in in a row field and 3 other categories in a column field and numeric values at the crossing points of the categories plus column totals at the bottom. This is a pivot table already.

The second picture shows a normalized table with one date column and one column of values. There is no additional category as in the column field of the previous example.
You can easily create a pivot with dates in a column field and then group the pivot's date field by year, quarter month but there is no such functionality for week days.
For week days you can add a calculated field to the source data and use this one instead of the date.
=TEXT(A1;"NNN") returns the weekday name of any date in A1