Skip to Content
0
Aug 04, 2023 at 09:58 AM

Query CELLS - show only 1 row for some formulas

283 Views Last edit Aug 11, 2023 at 02:18 PM 3 rev

Hi,

Just wanted to check if there is a way to achieve this in report in query designer or workbook?

So I have this FORMULA 1 (with specific formula like summation or average or whatever).

Let's say I need to SUM the values of PC SET 1, 2, and 3 but FORMULA 1 should only appear as 1 ROW similar to the image below. Is it possible? How to achieve it?

microsoftteams-image-1.png

SHOULD BE:

microsoftteams-image.png

Thanks.

Loed

Attachments