i have attached my required table. in that i want highlighted fields .please help me friends.

[#1]

i have attached my required table. in that i want highlighted fields .please help me friends.

[#2]

yes .Mindaugas.please help me

[ashishkalia]

#ravi m

Please open the attached document and u'll get the solution.

Cheers.....

Please tell me weather it worked or not.

[MindaugasBacius]

According to what rule the rows need to be removed? What is the logic?

I see than on Jan all the rows with less than 100 are removed. But this rules do not apply to Feb and Mar.

Do you need to remove all the rows that in a single cell contains less than 100?

[ankit777]

hi

on what logic do you color the rows ?

[MindaugasBacius]

Please see the attachment.

A.version:
CrossTable(Cats, Data, 2)
LOAD [Cat 1],
     Cat2,
     Jan,
     feb,
     mar
FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1, filters(
Replace(1, top, StrCnd(null))
));


QUALIFY *;

B.version:
LOAD [Cat 1],
     Cat2,
     Jan,
     feb,
     mar
FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1, filters(
Replace(1, top, StrCnd(null)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 5)),
Remove(Row, Pos(Top, 6))
));

UNQUALIFY *;

A.version. The table looks like a correct data table. But while we do not know what rule to follow and what values to remove we cannot help you.

B.version. The table looks like you wish but without explanation I am not sure if this what you are looking for.

UPDATE: B version is the opposite you wish. I think you will get the concept