tabular

Greetings! The setup: tbl_MAIN has all my data in it. frm_MAIN MENU allows user to search based on five fields, and opens another form: frm_DETAIL which displays all the tbl_MAIN data on one screen. It's useful but it's kinda crazy and busy. It's good, I like it. frm_MAIN MENU also opens up...

I am getting a "compile error object required" at set lastrow. Not sure how to fix it so any help will be really appreciated. Thanks. Sub copydata() Dim lastrow As Long Dim CrossTBrow Dim i As Long Set lastrow = Worksheets("Trial Balance").Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To...

Hello, I have two tables that are maintained separately, but share common elements. Based on those common elements, I would like to merge the tables and extend them into a full data list. The first table has headings across the top (let's call them location groups) that need to be looked up in...

2010 Excel I'm using tabular buttons to raise or lower the value of a cell. The problem is the upper button (pointing up) lowers the value, while the lower button (pointing down) raises the value. How can I reverse these so the upper button raises and the lower button lowers the value?

Hi My data is in a quite simple, tabular format as in the image below. I can use a pivot table to get a high-level summary. What I need to do then is to prepare data for a mail merge to each person, which will provide information with more granularity. E.g. will tell Mike he has £250 with...

All we got from the client is the final pivot table, we do not the source tabular data. Can I UNpivot it to get back to my raw data? thanks Jeff

D5=1 , 1cells need to appear as well as 1 tabular form need to appear D5=2 , 2 cells need to appear as well as 2 tabular form need to appear D5=3 , 3 cells need to appear as well as 3 tabular form need to appear i have used this formula,,it is working when the condition is met it is appearing...

I am trying to filter a pivot table to display the very first record within a field. I am trying to get the first invoice number for a customer. As of now, I am getting multiple records, and have been unable to set some sort of filter to only get the first invoice. My data is organized in a...

I've literally run out of things to try. I have cubes deployed to an SSAS Tabular instance. They have Dynamic Roles set up to limit data to only data they should have access to. This Role has Everyone assigned to it. It seems to be functioning fine for everyone at the company so far except 1...

Goal: Have a measurement for each PK_test row based on sum of all its quantity from productNumber. PK_test qty productNumber ----------------------------------------------- 1 5 asdf 2 4 asdf 3...

Is it possible to create some stored procedure and Views with DAX code in SQL server 2012 SSAS tabular?

My primary question is: How should I enable to make column "name" from table fact_B to be displayed inside of table Fact_A by with support of DAX code only? Additional info: - In this context, I cant use SQL code - The relationship is one to may between fact and dim table in the tabular...

I have a table with column: table A (int) (int) (int) (int) PK_g cost FK_a FK_b 123 5 23 55 454 5 234 58 I need to create a superkey as an additional column in the table A by using DAX code. How should I do it? It would be a calculated column...

Is DAX:s one of the purpose to increase more row in a table? For instance if you have a table named H with 20 rows. If you inner join table H with table T and you will retrieve 200000 new row. Again, is DAX code is built to go dealing with this task?

Hey all, I find that I constantly have to manually change particular pivot table row label fields to tabular view format, then turn off subtotals for that field. I would like to save a considerable amount of time and make a macro combining these two actions. The fields will almost never have...

I have an email folder with multiple emails that contain similar content. I would like a quick way to move all the data into Excel. Separating each contact by columns is the goal: sent, to, date, email body etc. I know I can save each email into notepad and copy into Excel and transpose but...

Hello Guys, I am trying to create a form that is based on a query that reports the next due date for a specific task (that happens every 2-weeks). This query is based of the Activity Table (e.g. TblActivity) and filters by the max of date last completed and creates a due date for the next due...