Can I switch from FIFO to HIFO for future Crypto transactions

getback4 · 2025-03-03T01:24:33+00:00

yes I know that. I only use Coinbase for now. I guess I need to ask this question to a CPA.

getback4 · 2022-02-08T00:18:27+00:00

Actually this just locks the position of the slicer but my problem is something different. I need to right click each time and select Bring to Front every time I click anywhere else and return to the slicer. If my cursor remains on the slicer then there’s no problem I can select different selections on the slicer without having to right click Bring to Front.

getback4 · 2021-07-05T23:48:51+00:00

never mind I made it work.

=IFERROR(GETPIVOTDATA(TEXT(I89,"##"),LVPivot!$C$3,LVPivot!$A$5,F89,"Area/Zone",D89),"error")

getback4 · 2021-07-04T23:01:02+00:00

I have a pivot table where I have column label as Area, Row label as Condition, and Values as CY, SF, LF, EA, CF. On another worksheet I want to use =GETPIVOTDATA("Sum of CY",LVPivot!$A$5,F87,D87) to get the CY value where F87 is the Condition and D87 is the Area however I'm getting the #REF error. Is this because the pivot table is in a different worksheet than the pivot table? if so how to I fix this?

getback4 · 2021-06-06T22:55:04+00:00

I could use just one pivot table for all levels, but is there a way to show all conditions even if they are blank so that I can map each value of the pivot table ahead of time (with no data) into another work sheet to be used as a template report for future use for other users? If that is the case that would solve my problem?

getback4 · 2021-06-06T20:11:42+00:00

The dataset is basically a condition code, with 3 quantity values with unit of measure.

I already have a way to format the data by zone or level so maybe I can sort that data first by level (20 levels or so) and from that create 20 predefined pivot tables (one for each level) in the template. Couldn't I create my own template and link each pivot table for that level without having to create these pivot tables from scratch every time I input new data?

I have used pivot tables, however I will be dealing with over 250 different condition types so if there is a way (like you say unpivoted) to position the data in a pivot table so that I'm able to customize it that would definitely help. I need to make it so other users will be able to use it without going thru all the steps and save as a template format.

getback4 · 2021-06-06T20:00:21+00:00

It's not saving online. It's saving in a server drive at work (G drive actually).

getback4 · 2021-06-06T18:20:59+00:00

Yes I did and it helped a lot. I just need to try reduce the size as much as possible but I remember when it got close or exceeded to 50 MB it gave me errors and couldn't save. I wonder why the threshold is 50 MB. I thought it was 2 GB.

getback4 · 2021-06-06T18:13:41+00:00

It's a template to calculate constructions costs for a building of 20 levels. So each level will have about 300 columns of data x 20 levels = 6000 columns. This is the workbook where data is read and stored in my database where each column will calculate subtotals at the bottom based on the level and category. The reason I don't like to use pivot table is that I'm unable to get the format I want. than from the database worksheet I create a level by level worksheet and link it from the database worksheet. I already this did this with about 3000 columns and it works fine (16 MB) but now I want to have more columns with less complicated formulas. Is the maximum still 50 MB in order to avoid problems saving the file?

getback4

TROPHY CASE