Search Result

Okay, so I know the question is really mixed up right there, but that's not exactly what I mean. I think it will be clearer if I give you the situation.

I have this table T that contains 3 columns. Let's say columns x, y, and z. and I want an application-generated table G where the values under T.x goes as the column header for table G, T.y becomes the row header, and Z the value stored within (x,y). You see, I was planning on making...

Okay, so basically, I want to convert rows to columns. But the row distinctions don't have an exact number. They can be changed by the user. So how do I use PIVOT if the number of distinct rows are dynamic?

I have built a data viewer in C#.Net for the accounts department that allows them to dig through cubes of financial data and export sets to excel but my boss has asked for the ability to create and manipulate pivot tables (based on this data) within the application rather than having to export to Excel and do it there.

Does anyone know of a good add-in that will provide this graphical functionality?

Hi everyone(:

I'm having trouble creating pivot tables using macros.

First i tried recording it then running the exact same thing. It worked fine the first time but a week later when i tried it again the pivot table failed me. As i am using raw data as the data source, hence the number of rows changes everyday and therefore the datasource for the pivot table code cannot be fixed.

How do i do this?...

have a page that dynamically builds forms input fields from a table allowing users to enter input into the form. Each input is a field in a _info table.

I would like report showing all of the entries of a user in one line. Each field entry is a row. So I need to take the vertical data and make it horizonal. There are many different forms with different configurations so must be dynamic. I’ve come across a lot of articles for cross-tab...

Hi,
Excel experts - evidently, Excel 2003 pivot table had a built in capability to parce out the pivot table into separate tabs based on one field values. E.g. If the pivot table had a region field with 4 regions in it - South, North, East and West - this built in capability allowed you to click on the Region field, etc and Excel would create 4 individual tabs with pivots for South, North, East and West.

I cannot find this...

Hi,

If I have a cross tab query which counts an [id number] and pivots on a [status] for a [course], how do I add a new row heading that will sum only a certain few status's. E.g. The [status] field has "A", "B", "C", "D". I want to add a row heading that is the sum of [id numbers] under "A" and "D"?

Thanks