Agar siz bir sotuvdagi barcha mahsulotlarni ko‘rsatib, ularni ma’lum tartibda chiqarishni istasangiz, ORDERBY + SELECT formulasidan foydalaning.
👉 Misol:
ORDERBY(
SELECT(
Products in Active_Sale[Product ID],
[Sale ID] = [_THISROW].[Sale ID]
),
[Label],
FALSE
)
🔑 Bu formula:
— Joriy Sale ID ga tegishli barcha Product ID larni yig‘adi;
— Ularni Label bo‘yicha tartiblaydi (FALSE → ko‘payish tartibida).
⚡️ Natija: foydalanuvchi bitta ustunda tartiblangan mahsulotlar ro‘yxatini ko‘radi.
ℹ️ Muhammadjavohir Sur'atov bilan o'tgan masterklassdan
@AppSheetSolutions
