11 Replies Latest reply on Oct 8, 2018 1:52 AM by Tushar More

How to combine LODs and LOOKUP or something like this

Hello All!

I have a data table that contain Sale information for each Subproduct. It's here: Calculate - Product Name - Google Sheets

Now I want to draw a cross table that show SUM(Sale) of "Type A Product" (not Subproduct) everyday.

"Type A Product" is any Product has [SUM(Sale) Today] > [SUM(Sale) Yesterday]. I tried to combine FIXED and LOOKUP function but it's error

Thanks so much!

• 1. Re: How to combine LODs and LOOKUP or something like this

Hi Cong,

Please check the attached workbook.

Let me know it helps or not.

~Tushar

• 2. Re: How to combine LODs and LOOKUP or something like this

Hi Tushar

I mean I want to draw a cross table that have: Row is [Order Date] and Text is SUM[Sale of "Type A Product"]

So the exactly result is:

9/1/2018:  -

9/2/2018:   150      (Banana + Mango)

9/3/2018:   30        (Apple)

9/4/2018:   10        (Banana)

Thanks so much!

• 3. Re: How to combine LODs and LOOKUP or something like this

Hello,

You have marked the thread as assumed answered. Are you still looking for the answer?

• 4. Re: How to combine LODs and LOOKUP or something like this

Yes, I still.

Sorry, I dont know why the answered be assumed. Maybe I click something wrongly

• 5. Re: How to combine LODs and LOOKUP or something like this

You can open the main thread not the inbox view and look for the option to change it to unanswered. And I think i got the answer.

• 6. Re: How to combine LODs and LOOKUP or something like this

Great Tushar  More!! Could you please send me the workbook?

• 7. Re: How to combine LODs and LOOKUP or something like this

Check the attached workbook v10.3.

~Tushar

If that helps, mark my response as correct / helpful to close the thread.

1 of 1 people found this helpful
• 8. Re: How to combine LODs and LOOKUP or something like this

Hi Tushar,

I created a new sheet and tried to make it same with your sheet but why doesn't it work?

• 9. Re: How to combine LODs and LOOKUP or something like this

You need to turn off the stack marks.

~Tushar

1 of 1 people found this helpful
• 10. Re: How to combine LODs and LOOKUP or something like this

That's so amazing. Thank you, Tushar

• 11. Re: How to combine LODs and LOOKUP or something like this

You are welcome! Please mark any of my response as correct to close this thread.

~Tushar